cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors