Forum Discussion
Count Distinct IDs Based on two Filter Criteria
I have a table with IDs that I would like to create a measure to count the IDs based on two criteria. I want to count those IDs when the two criteria match Example If Criteria 1 & 2 are...
Anonymous Please try this, it will work for both as a "New Column" or "Measure"
CALCULATE(COUNTROWS(Test03Count),ALLEXCEPT(Test03Count,Test03Count[Criteria1],Test03Count[Criteria2]))