Forum Discussion
Solved
Count rows from filtered measure
I have tried and tried to look for a solution, and didn't find anything that wasn't confusing. I must be over thinking this... Here is my data, it's so very simple...only one column named Animal, wi...
Try this measures...
Single_Occurrence = VAR A = SUMMARIZE('Table (2)','Table (2)'[Animal],"Count1",COUNT('Table (2)'[Animal])) RETURN CALCULATE(COUNT('Table (2)'[Animal]),FILTER(a,[Count1]=1))Multiple_Occurrence = VAR A = SUMMARIZE('Table (2)','Table (2)'[Animal],"Count1",COUNT('Table (2)'[Animal])) RETURN CALCULATE(COUNT('Table (2)'[Animal]),FILTER(a,[Count1]>1))If it helps, mark it as a solution
Kudos are nice too
I do not see ANY option to mark this as solved....
All I see is a thumb for Kudos , the number of kudos given and reply..
that's it