Forum Discussion

dungtran's avatar
dungtran
Regular Visitor
2 years ago
Solved

Could you see what's wrong with the DAX Switch function?

Hello,

   I have a very sample DAX Switch function to create a new column of Total Sales greater than 6 millions But it does not work correctly in the report. Could you please help to see why?

 

    Dax Switch function :  

 

 

Column of checking sum of list price for each country = SWITCH(true(),SUM(TrainingSample2[ListPrice])>6000000,"Sum of List Price greater than 6 Millions","Sum of List Price Below 6 Millions")

 

 

The Report

 

 

Thanks,

Dm

Need Help
  • dungtran's avatar
    dungtran
    2 years ago

    Hello,

       Thank you. The problem is resolved. I need to use the create new measure for the calculate dax function.

    DM

2 Replies

  • dungtran's avatar
    dungtran
    Regular Visitor
    2 years ago

    Hello,

       Thank you. The problem is resolved. I need to use the create new measure for the calculate dax function.

    DM

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    2 years ago

    Nice day!!
    MMH since it's a simple condition test with an if instead, it should work