Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@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
@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
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |