Forum Discussion

giorgiokatr's avatar
giorgiokatr
Icon for Helper V rankHelper V
9 years ago
Solved

sum different columns depending on a slicer selection

I have two tables   Date | MTD | QTD | YTD   second table is Selection MTD QTD YTD   slicer hav the values of second table is there any other way than using if to have sum of MTD column of...
Need Help
  • Baskar's avatar
    Baskar
    9 years ago

    Cool, 

     

    Try this  it will help u, if not let me know.

     

     

     

    Note : 

    If u select multiple option it will move to Others part.

     

giorgiokatr's avatar
giorgiokatr
Icon for Helper V rankHelper V
9 years ago

Cool Baskar! So you create a var in order to avoid writing the if statement inside switch? Thanks!

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

Yes u r correct my friend. Var is more powerfull function in DAX.

 

It will help u in many situation, and good performance too.

 

:-)

  • giorgiokatr's avatar
    giorgiokatr
    Icon for Helper V rankHelper V
    9 years ago

    Thanks Baskar! Can this var used in another measure? eg

     

    SWITCH(Filter_Value,"MTD",SUM('MTD),"QTD",SUM(QTD),"YTD",SUM(YTD),"")
    • Baskar's avatar
      Baskar
      Icon for Resident Rockstar rankResident Rockstar
      9 years ago

      No, Var only used inside the measure , we can't use outside .

       

      Cool