Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Using a measure inside a Switch

Hi everyone, is there a way to create a switch function from a measure?

 

I have seen: SWITCH( Table[ column]... etc 

 

I need to group a measure, to put it in rows. (not in a filter, but in rows)

I have Data% as a measure = 

 

DATA% = IF(ISBLANK([DATA-OrderCount]/[OrderNumberCount]),0,[DATA-OrderCount]/[OrderNumberCount])

This is my goal:

 

 

 

and this is how my data looks and this is what I need my result to look for (Remember, DATA% is a measure)

fyi, I have created a filter with the help of one forum here (using a separate table https://www.youtube.com/watch?v=AZAL-QPn5Zc), BUT I am NOT  looking for that because I am unable to bring or connect the CustomerCount to the options in the filter (unless there is a way to do this connection, then that is what I am looking for)

Thank you in advance!!