Need to Calculate Difference in column data that is filtered and not-filtered

[DB23]

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.  

[v-chuncz-msft · Accepted solution]

@DB23 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Plot-difference-between-two-rows-based-on-slicer-selection/...

[Greg_Deckler]

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.