Forum Discussion
Counting Distinct Column then Distinct Row
Hello all, I've dug through the forums to try and narrow down my question, but have yet to find an exact answer. Please see example data here: What I am trying to do is: 1. Do a distinct ...
Try a formula like this:
Measure =
COUNTROWS(
CALCULATETABLE(
VALUES(Sheet1[ID]),
Sheet1[Rating] = "Pass"
)
)