Forum Discussion
Find what values exist in Col1 where in multiple rows, each row with different condition met in Col2
Hey Everyone, I am trying to do something extreamly specific and not sure if its even possible within Power BI. I have a table with users and intrest, looks similar to the image below. ...
mahenkj2
Solution Sage
Solution SageHi Vaiden
Its possible by few ways at least.
One ways, is kind of grouping by Users, and if count is more than once in the table, then we can filter those.
for example,
Counts = CALCULATE(COUNTROWS('Table'),ALL('Table'[Interest]))
and in the visual level filter, apply filter for these counts >1.
Hope it helps.