Forum Discussion
How to distinct count with filter - counting measures
Hello, Im trying to create a bar chart that counts how many of my Items are either A, B or C I've tried the following fomula: CountA = COUNTROWS(FILTER('Table', [Chart] = "A" )) CountB...
Hi Anonymous ,
Oh ,got it!
I built another data sample :
And the [Chart] is a measure not column:
Chart = IF(MAX('Table'[Column1])>10,"A","B")Then please try:
Count A = var _t=SUMMARIZE('Table',[Index],"Chart",[Chart]) return COUNTROWS(FILTER(_t,[Chart]="A"))Count B = var _t=SUMMARIZE('Table',[Index],"Chart",[Chart]) return COUNTROWS(FILTER(_t,[Chart]="B"))Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous can you give an example of what you mean when you say "its not counting how many have A, B, C"?
Your code is working fine in my testing.
CountA =
CALCULATE(
DISTINCTCOUNT('Table'[Item]),
FILTER('Table', [Chart] = "A")
)
CountB =
CALCULATE(
DISTINCTCOUNT('Table'[Item]),
FILTER('Table', [Chart] = "B")
)
I did each measure individually, maybe thats why. Im getting a red underline right now with CountB and CountC, How would I write this in full?
Anonymous I'm sorry I wasn't clear - those should be written as separate measures. I've edited to clarify.