Forum Discussion

bluetronics's avatar
bluetronics
Icon for Helper III rankHelper III
3 years ago
Solved

How to use switch function

Hello All, Anyone can teach me how to get the result withot filter like below:     Dax that I typed in:   Customer_80-20 = SWITCH(true(), Sheet1[Cumulated % of Customer] <=0.8, "80"...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    3 years ago

    Hi bluetronics ,

     

    Please try the measure.

     

    Measure = CALCULATE( [Customer_80-20], ALLSELECTED(Sheet1[Product])) & "-" & CALCULATE([Product_80-20], ALLSELECTED(Sheet1[Customer]))

     

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi bluetronics ,

 

Please try the measure.

 

Measure = CALCULATE( [Customer_80-20], ALLSELECTED(Sheet1[Product])) & "-" & CALCULATE([Product_80-20], ALLSELECTED(Sheet1[Customer]))

 

  • bluetronics's avatar
    bluetronics
    Icon for Helper III rankHelper III
    3 years ago

    Hi v-kkf-msft,

    Thank you for providing me a solution. it works perfectly.

    Best Regards,