Forum Discussion

a119526's avatar
a119526
Frequent Visitor
4 years ago

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

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 

Need Help

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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.