Forum Discussion
Measure 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"))
2 Replies
Hi Anonymous ,
Not sure, but would you provide us a diagram of the relationships? Also it might be helpful to copy and paste a set of dummy tables with the column headings and some dummy data to work with. I realize that the actual data may be propietary. However if you copy and paste into the post of the dummy data it would be good. Posting a picture, might be somewhat helpful, but we can't work on that.
Please read this post to get your question answered more quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
NathanielAnonymous how you resolved this problem, I'm facing this. Can you please suggest me the solution?
