Creating Dynamic Groups

[Mainer04401]

I'm trying to create custom groups of stores based on sales using an IF expression.  I want to be able to use these groups as a filter or in the axis of a chart, so I think that the groups have to be a column, not a measure.  The trouble is, I want to filter the data by a date range and geography, and if I create a column with an IF statement, it's static and cannot be filtered.  

Any suggestions?

[v-lionel-msft]

Hi @Mainer04401 ,

"  The trouble is, I want to filter the data by a date range and geography, and if I create a column with an IF statement, it's static and cannot be filtered.  "

In fact, calculated columns can also achieve dynamic effects.

Best regards,
Lionel Chen

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

[Terrance]

Search for and select Groups. Select All groups, and select New group. On the Group page, enter a name and description for the new group. Select a Membership type for either users or devices and then select Add dynamic query.

[v-lionel-msft]

Hi @Mainer04401 ,

Please give us the sample data and explain the result you want to calculate.

Best regards,
Lionel Chen

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

[amitchandak]

@Mainer04401 

Better create a column using if or switch true.

Also refer : https://radacad.com/grouping-and-binning-step-towards-better-data-visualization