Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Create Different Groups From One Datasource based on End User Specifications

Hello,   I am trying to create a "calculator" of sorts where an end user can specify 2 groups from multiple fields. I would then like to use these groups for further analysis. For Example:   Base...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

You can create a calculator for each group.

The following DAX might work for you:

 

Group1 = 
CALCULATETABLE(
    'Table',
    FILTER(
        'Table',
        'Table'[Sex] = "F" && 'Table'[Race] = "Black"
    )
)


Group2 = 
CALCULATETABLE(
    'Table',
    FILTER(
        'Table',
        'Table'[Sex] = "M" && 'Table'[Race] = "Asian"
    )
)

 

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.