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
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 1
pls see the attachment below
It worked. Really thankful for your help!
you are welcome