Forum Discussion
Measures not filtering table
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:
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"))
3 Replies
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 cannot be achieved directly. But you may take a look at the posts below.
