Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi!
I've been spending my day banging head to the wall with this problem. I need to check if value is a duplicate of value in the same column that is filtered by slicer.
Slicer | Part code | Has duplicates |
1 | 14 | FALSE |
1 | 15 | FALSE |
1 | 16 | FALSE |
2 | 14 | TRUE |
2 | 15 | FALSE |
2 | 16 | FALSE |
2 | 14 | TRUE |
I was going for the COUNTROWS with EARLIER, but I'm unable to keep the correct context. I keep getting the false positives for the part codes that are being used by a different slicer.
Thanks in advance!
Solved! Go to Solution.
Hi,
my first thought was to concatenate both columns and then start the count with earlier.
Have a look at my screenshot
Hi,
my first thought was to concatenate both columns and then start the count with earlier.
Have a look at my screenshot
Hi,
Thanks! That is so simple and effective.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |