Forum Discussion

khisla's avatar
khisla
Icon for Helper II rankHelper II
1 year ago
Solved

DAX Command - IF variables, SWITCH and COALESCE

I need a DAX commend to identify the store to which an employee is based to sales commission calculation purposes Please find table of specific scenarios and expected results for each one. So I hav...
DAX help needed
  • Cookistador's avatar
    Cookistador
    1 year ago

    Hello khisla 
    You added one ) in your second condition in the CASE
    Normally, the following measure should work

    Next=

 VAR EntranceStore = SELECTEDVALUE('HILAN'[Entrance Store])
 VAR ExitStore = SELECTEDVALUE('HILAN'[Exit Store])
 VAR DefaultStore = SELECTEDVALUE('HILAN'[Employee Default Store])

RETURN
   SWITCH(
   TRUE(),
   NOT(ISBLANK(EntranceStore)) && EntranceStore <> DefaultStore, EntranceStore,
   NOT(ISBLANK(ExitStore)) && ExitStore <> DefaultStore, ExitStore,
   NOT(ISBLANK(EntranceStore)) || EntranceStore = DefaultStore || ISBLANK(ExitStore) || ExitStore = DefaultStore, DefaultStore,
     DefaultStore
    )



V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi khisla ,

Thanks for posting your query in the Microsoft Fabric Community. I’ve validated Cookistador , approach in my Power BI report, and it works as expected in all scenarios. for your refere attached the .pbix file for you to review or verify the implementation if needed. Cookistador  response provides the expected results please review it for confirmation.

 

Thanks, Cookistador , for sharing the correct DAX logic .

 

Best regards,
Yugandhar.

khisla's avatar
khisla
Icon for Helper II rankHelper II
1 year ago

Got an error message

 

 

  • Cookistador's avatar
    Cookistador
    Icon for Super User rankSuper User
    1 year ago

    Hello khisla 
    You added one ) in your second condition in the CASE
    Normally, the following measure should work

    Next=

 VAR EntranceStore = SELECTEDVALUE('HILAN'[Entrance Store])
 VAR ExitStore = SELECTEDVALUE('HILAN'[Exit Store])
 VAR DefaultStore = SELECTEDVALUE('HILAN'[Employee Default Store])

RETURN
   SWITCH(
   TRUE(),
   NOT(ISBLANK(EntranceStore)) && EntranceStore <> DefaultStore, EntranceStore,
   NOT(ISBLANK(ExitStore)) && ExitStore <> DefaultStore, ExitStore,
   NOT(ISBLANK(EntranceStore)) || EntranceStore = DefaultStore || ISBLANK(ExitStore) || ExitStore = DefaultStore, DefaultStore,
     DefaultStore
    )



  • V-yubandi-msft's avatar
    V-yubandi-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi khisla ,

    Have you been able to review the PBIX file I attached? If not, please check it when you have a moment. The logic in that file has been implemented correctly.

     

    Thank You.