Forum Discussion

NickProp28's avatar
NickProp28
Icon for Post Partisan rankPost Partisan
6 years ago
Solved

Perform conditional DAX in Slicer

Dear Community,   I have a 4 column in my table, which is Country, Code, Profit and Revenue. Country Code Profit Revenue PVG ABC 1000 4000 IND DEF 2000 5000 UK QWE 3000 600...
Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    NickProp28 ,

    Try to revamp it like below code:

    Final Measure = Switch(True(), MAX(Table[County])="PVG",Calculate( Measure, Table[Code] NOT IN {"ABC", "DEF"}), Table[County]="IND", Calculate( Measure, Table[Code] IN {"ABC", "DEF"}))

     

    NOTE: Measure is the name of calulcated profit which you just posted above.

     

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi , NickProp28 

Do you have resolved it? If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

NickProp28's avatar
NickProp28
Icon for Post Partisan rankPost Partisan
6 years ago

Dear Tahreem24 v-easonf-msft,

Sorry for my late response, its help. But last time I had accept it as solution, might due to my internet issue and cause pages does not run completly. 

Thank again Tahreem24 .