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
laurianoe
New Member

DAX - 2 Slicers coming from the same field

Hello,

 

I am looking to see if I can get some help with a DAX Calculation or any other possible routes to approach the problem. The situation that I have is that I have a requirement where the business users would like to see the total sum of sales and the sales variance between two different categories (category value will come from the same category column). The problem that I have is when I make a DAX calculation to get the variance between the two categories it returns a blank value.

 

Currently what I am doing is duplicating my category filter slicer and I edit the interactions so they are not conflicting with each other.

 

laurianoe_0-1649876277118.png

 

I then create a DAX calculation to calculate the YTD sum of sales

 

Totals_YTD = CALCULATE('FactSales'[Sales Total], DATESYTD('DimTime'[Time]))

 

Totals_YTD_2 = CALCULATE('FactSales'[Sales Total], DATESYTD('DimTime'[Time]))

 

I then insert these calculations onto a card and apply the necessary category filter slicers and any other filters that are needed for each card.

 

laurianoe_1-1649876277126.png

 

laurianoe_2-1649876277137.png

 

 

 

Once I have these two cards ready, I then make a third card where this will display the variance (difference) between the two categories. 

 

Difference = Totals_YTD – Totals_YTD_2

 

However the card will return a blank value.

 

laurianoe_3-1649876277142.png

 

                     

laurianoe_4-1649876277152.png

 

 

 

A work around that I’ve been able to find is that I have to duplicate my fact table to achieve the desired result. The only issue with this, is that it takes up a lot of space and I would like to avoid this route.

 

Any suggestions would be appreciated!

1 ACCEPTED SOLUTION
truptis
Community Champion
Community Champion

Hi @laurianoe , 

Yes, you can have the second slicer for category coming from a duplicate table but if you don't wish to go through that option then you can refer the below link :

https://medium.com/creative-data/comparing-selected-categories-in-power-bi-b2ceedf78bfd 

 

@laurianoe Please hit the thumbs up & mark it as a solution if it helps you. Thanks.

View solution in original post

1 REPLY 1
truptis
Community Champion
Community Champion

Hi @laurianoe , 

Yes, you can have the second slicer for category coming from a duplicate table but if you don't wish to go through that option then you can refer the below link :

https://medium.com/creative-data/comparing-selected-categories-in-power-bi-b2ceedf78bfd 

 

@laurianoe Please hit the thumbs up & mark it as a solution if it helps you. Thanks.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.