Forum Discussion
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...
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.
Would this allow for end users to choose the criteria for each group?
Enable "Personalize Visuals" and teach your users how to use it.
Hi Anonymous ,
Unfortunately it is static, and at the time of founding the calculation group, its conditions were specified
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.
