Calculated table variables

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.