Add index column to measure

[Anonymous]

Hi Experts

How would you add an index column to the following measure

Channel_Grp = DISTINCT(SELECTCOLUMNS(Profitability_Consolidation,"Channel",Profitability_Consolidation[Channel]))

The Index order should be

1. All

2. IAM

3. OES

[Anonymous · Accepted solution]

HI @Anonymous,

It seems like you want to set an index of your channel value. For this scenario, I'd like to suggest you use the switch function to manually convert these to return specific index values.

DAX – Making the “Case” for SWITCH() 

Regards,

Xiaoxin Sheng