Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am trying to calculate the difference between total sales related to a selected/filtered price and total sales related to not selected prices.
For example if my selected price of $1.50 shows average weekly sales of $500,000 and I have another price of $2.00 to which I sold average $250,000, I want to be able to show on the $2.00 row a difference of -$250,000 ($250,000 - $500,000).
The problem I run into is the filter will only show calculations related to the filtered price of $1.50 so I need to edit the relationship, but I need to utilize the SelectedValue function so that the filtered price is identified for calculating the difference in the other rows.
Solved! Go to Solution.
You may take a look at the post below.
You may take a look at the post below.
Difficult to say. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Might need to use ALL or ALLEXCEPT or REMOVEFILTERS somewhere.