Using ALL to exclude a visual-level filter based on a measure and not a column.

[a119526]

Hi All - 

I have two seperate tables. One captures the price decreases and the other captures the price increases. 

I am trying to calculate the price impact in comparison to total last years sales. The issue I have is I am using a visual-level filter to filter on this price impact to show items greater than or equal to 0 in one table, and less than 0 in the other.  This causes the total last years sales amount to change. This price impact field is a MEASURE and I cannot use ALL to filter on a measure. Is there a way to address this so that last years sales does not change based on the price impact selection?

Any help would be greatly appreciated.

Below is link to sample data. Please see the 'Top and Bottom Products' tab. 

https://drive.google.com/file/d/1rCWbFofMUA3zevdKwLk8P5lvLBmKea72/view?usp=sharing 

[v-yanjiang-msft]

Hi @a119526 ,

According to your description, it depends on the code of the total last years sales, but I have no access to your sample link, could you please provide more details?

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.