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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.