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 ;
According to your description, you could create a new table as filter value, then create measures as follows:
1.create a new table.
newtable = SUMMARIZE('PSUserInfo',[tp_Title],PSUserInfo[dt])2.replace filter visual .
3.create measures(count and distincount)
count = IF(DISTINCTCOUNT('newtable'[tp_Title])>1,COUNT([ResourceUID]),CALCULATE(COUNT([ResourceUID]),FILTER(PSUserInfo,[tp_Title]<>MAX('newtable'[tp_Title]))))discount = IF(DISTINCTCOUNT('newtable'[tp_Title])>1,DISTINCTCOUNT([ResourceUID]),CALCULATE(DISTINCTCOUNT([ResourceUID]),FILTER(PSUserInfo,[tp_Title]<>MAX('newtable'[tp_Title]))))4.change other four visual's Field.
The final output is shown below:
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, in your solution selected value don't filter in table (it is selection). I meen, that I have only one value in table after selection.