Forum Discussion

SBR1D's avatar
SBR1D
Helper III
2 years ago
Solved

Calculated table variables

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
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.