Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
giorgiokatr
Helper V
Helper V

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?

1 ACCEPTED SOLUTION
Baskar
Resident Rockstar
Resident Rockstar

Cool, 

 

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

1.JPG

 

 

 

Note : 

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

 

View solution in original post

6 REPLIES 6
Baskar
Resident Rockstar
Resident Rockstar

Cool, 

 

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

1.JPG

 

 

 

Note : 

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

 

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

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

 

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

 

🙂

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

 

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

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

 

Cool

giorgiokatr
Helper V
Helper V

think i found it

its switch...?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.