The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I want to achieve something akin to this (this populates a column as true if the number of rows, filtered, is > 1 where the filters in ALLEXCEPT are the same).
What I need to find now is similar, except the PolicyReference needs to be the same, but Product OR ProductType OR Term are different. I'm assuming my starting point (trying to amend this) is not a good idea, but I can't see a way to achieve what I need
Solved! Go to Solution.
I did it in two stages, used the first to ID where they were the same, then checked that in a second stage
I did it in two stages, used the first to ID where they were the same, then checked that in a second stage
@RichHead1821 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
HI, yes, sample data would be single table (factSoldCovers):
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |