Measures not filtering table

[Anonymous]

I have a table of client accounts, and I want to have a pie chart that shows the count of clients whose accounts are above a certain value (selected in a dropdown) and those whose are below - this part works. I however also have a table of account numbers, account names and account values; when the user selects the "above" piece of the piechart, the table must only show those accounts who are above the value, and only show those below if the user clicks on that piece of the piechart - this however is not working, it just continues to show all results.

Measures:

Threshold Check = IF(SUM(Table[AccountValue]) >= SELECTEDVALUE(ValueThreshold[Threshold]), "Above", "Below")

Accounts Above = CALCULATE(DISTINCTCOUNT(Table[AccountNumber]),FILTER(VALUES(Table[AccountNumber]),[Threshold Check]="Above"))

Accounts Below= CALCULATE(DISTINCTCOUNT(Table[AccountNumber]),FILTER(VALUES(Table[AccountNumber]),[Threshold Check]="Below"))

[v-chuncz-msft]

@Anonymous 

This cannot be achieved directly. But you may take a look at the posts below.

• https://community.powerbi.com/t5/Desktop/Create-a-bar-graph-with-measures-as-axis/td-p/455900
• https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846

[amitchandak]

Remove values  or try directly

Accounts Above = CALCULATE(DISTINCTCOUNT(Table[AccountNumber]),Threshold Check="Above"))
Accounts Below= CALCULATE(DISTINCTCOUNT(Table[AccountNumber]),FILTER((Table[AccountNumber]),[Threshold Check]="Below"))

[Anonymous]

This does not work, it says: "A function 'CALCULATE' has been used in a True/Fasle expression that is used as a table filter expression. This is not allowed."