Forum Discussion
Solved
Multiple column selection in one table with slicer
Hi All, I am trying to create a table with one column with a combination of multiple column selection with a slicer Example : columns : Test Eye = Test Eye A, Test Eye B, Test Eye C, Tes...
Hi ravindranraman ,
Please refer to this post.
There's a potential solution in it and also a pbix file attached for your reference.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Will this work as i have a large set of data with multiple columns?
I was trying this but it only picks up one expression
CALCULATE(FIRSTNONBLANK(Table1[_Test Eye A],Table1[_Test Eye A]),
FIRSTNONBLANK(Table1[_Test Nose A],Table1[_Test Nose A]),
FILTER(Table1,Table1[_Test Eye A]=SELECTEDVALUE(Slicer[Slicer])||(Table1[_Test Nose A]=SELECTEDVALUE(Slicer[Slicer])))))