Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
You can try the following measure that takes a distinct count of student IDs when the ethnic group name is blank.
Yep.
Amend the measure to
@jgeddes is it possible to add to the formula to get a "0" (zero) instead of (Blank)? when there are no students missing ethnicity?
Yep.
Amend the measure to
You can try the following measure that takes a distinct count of student IDs when the ethnic group name is blank.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |