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.
Hello all,
I have a table that looks something along the lines of this:
ID Status Number
100 1
100 2
100 1
101 1
101 6
101 2
101 1
105 2
105 2
203 7
203 1
323 5
323 1
445 5
445 2
489 1
512 2
What I want to do is create a measure that counts the number of distinct IDs that have at least 1 value that is not equal to 2, 5, or 7. So the output for this small table would be 5 since it would count 100, 101, 203, 323 and 489. It would not count 105, 445, or 512 since the only values that it has are 2, 5, or 7.
Thank you in advance for the help
Solved! Go to Solution.
Hello @Anonymous
Here is a measure that should do what you want:
Distinct IDs Status not 2,5,7 = CALCULATE ( DISTINCTCOUNT ( YourTable[ID] ), NOT YourTable[Status Number] IN { 2, 5, 7 } )
Does that work for you?
Regards,
Owen
Hello @Anonymous
Here is a measure that should do what you want:
Distinct IDs Status not 2,5,7 = CALCULATE ( DISTINCTCOUNT ( YourTable[ID] ), NOT YourTable[Status Number] IN { 2, 5, 7 } )
Does that work for you?
Regards,
Owen
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |