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 first table when MTD is selected etc?

Need Help
  • Anonymous's avatar
    Anonymous
    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.

     

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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 Anonymous! So you create a var in order to avoid writing the if statement inside switch? Thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable
        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.

         

        :-)