Forum Discussion
Solved
Need Help with Searching for One Value and Filtering by Another in Power BI
Hey everyone, I’m facing a challenge in Power BI and hoping someone can help me out. I have a dataset like this: Student Class John B Mary B Martin B Louis A Thomas A Andrew A My goal ...
you need to duplicated the table. One is for filtering and the other is for displaying.
then you create a measure
Measure =VAR _class=max('Table'[Class])return if (_class=max('Table 2'[Class]),1)add this measure to visual filter and set to 1pls see the attachment below
Hi martim0305 ,
Did the replies offered help you solve the problem, if it helps, you can consider to accept it as a solution so that more user can refer to, or if you have other problems, you can offer some information so that can provide more suggestion for you.
Best regards,
Lucy Chen