cancel
Showing results for
Did you mean:

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

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.

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.

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.

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
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 :

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

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 :

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