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
OliverTovar
Regular Visitor

How to create a difference between two measure which based on slicers

Situation:

1 Facttable with different planning Scenarios. e.g. Actual; Budgets, and a lot of more.

 

Now I would like to have two slicer which leads to seperate measure. These two measure than should be able to subtracts from each other.

 

OliverTovar_0-1620115530892.png

However the result does not show, because the value come from the same fact table and is then twice filtered. 
Does anyone have an Idea how to create such a solution.

 

Cheers,

Oliver

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@OliverTovar , you need one independent table for that

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

 

a better and similar example with date table

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@OliverTovar , you need one independent table for that

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

 

a better and similar example with date table

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

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.