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 ...
Hello all, sorry for the late response. I ended up utilizing this solution which I apologize I cannot find it but it worked well:
Pass =
CALCULATE(
DISTINCTCOUNT(Sheet1[ID]),
FILTER(Sheet1,Sheet1[Rating] = "PASS")
)