Filter table if a measure is selected

[Anonymous]

Hi,

I have a pie chart that has two measures in as values: Accounts Above and Accounts Below. These measures count the account numbers whose totals are above a certain value and count those below. 

If I select on the Accounts Above piece of the pie chart, I want to filter the table by only showing the Account Numbers whose totals are above the certain value. And if I select on the Accounts Below piece of the pie chart, I want to filter a table by only showing the Account Numbers whose totals are below the certain value.

Any idea how I can achieve this?

[amitchandak]

Is it a grouped value or line-level value?

[Anonymous]

Grouped

@amitchandak

[amitchandak]

If you want to replace the measure

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

If you need to filter values

measure = calculate([measure3],filter(table,[measure4]>0)

or

measure = calculate([measure3],values(Table[ID]),filter(table,[measure4]>0) //level at which you want to filter in values