Forum Discussion
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.
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
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
1 Reply
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