Using a measure inside a Switch

[Anonymous]

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!!

[amitchandak · Accepted solution]

@Anonymous , I think you need Dynamic Segmentation

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k