Forum Discussion
Filter value in same table after column value selection
Hi, Vasily_Zaytsev ;
In my second solution, If you click user 1 in the visual table, the other four visuals have been filtered by user1.such as :
however,you mentioned that only this user in table after click on it，This is impossible, because interaction refers to other visual objects. Clicking on itself cannot make itself only display user1, so you can copy a same table again, and it will only filter user1.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Vasily_Zaytsev
I'm sorry to understand error, and you could change the two measures as follows:
count = IF(DISTINCTCOUNT('newtable'[tp_Title])>=2,0,CALCULATE(COUNT([ResourceUID]),FILTER(PSUserInfo,[tp_Title]=MAX('newtable'[tp_Title]))))discount = IF(DISTINCTCOUNT('newtable'[tp_Title])>1,1,CALCULATE(DISTINCTCOUNT([ResourceUID]),FILTER(PSUserInfo,[tp_Title]=MAX('newtable'[tp_Title]))))The final output is shown below:
Since the pie chart is not displayed when it is 0, I think it is better to replace Header1 with a slicer in your own pbix.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, Yalan Wu.
In your second solution there are several values after selection (7 users). I need only one. If I click on user 1 in visual table I need filter all table by this value only (only this user in table after click on it).