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

[dungtran]

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

[Syndicate_Admin]

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

[dungtran · Accepted solution]

Hello,

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

DM