sum different columns depending on a slicer selection

[giorgiokatr]

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?

[Baskar · Accepted solution]

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]

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

[Baskar]

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]

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

SWITCH(Filter_Value,"MTD",SUM('MTD),"QTD",SUM(QTD),"YTD",SUM(YTD),"")

[Baskar]

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

Cool

[giorgiokatr]

think i found it

its switch...?