Calculated table variables

[SBR1D]

Hello

I've got a table where applicants have multiple rows depending on the application stage they are at.  I want to bring back a table of anyone that is of status code 1 OR 2 AND 5. Here is what i have so far, not sure if i am going about it the right way though. 

Thanks in advance

invited or new = VAR inv_or_new =  CALCULATETABLE('Application Progress Links','Application Progress Links'[Status (Code)] IN {1,2})
                
                VAR signed_up = CALCULATETABLE('Application Progress Links','Application Progress Links'[Status (Code)] =5 )
    RETURN  signed_up IN inv_or_new

[Anonymous · Accepted solution]

Hi @SBR1D ,

Please try to create a new table with below dax formula:

New Table =
VAR invited_or_new =
    CALCULATETABLE (
        'Application Progress Links',
        'Application Progress Links'[Status (Code)] IN { 1, 2 }
    )
VAR signed_up =
    CALCULATETABLE (
        'Application Progress Links',
        'Application Progress Links'[Status (Code)] = 5
    )
VAR combined_table =
    UNION ( invited_or_new, signed_up )
VAR final_table =
    INTERSECT ( invited_or_new, signed_up )
RETURN
    final_table

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

could you pls provde some sample data and expected output?