Forum Discussion

bluetronics's avatar
bluetronics
Icon for Helper III rankHelper III
4 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
    4 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
    4 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
      4 years ago

      Hi v-kkf-msft,

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

      Best Regards,