Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    Perfect, thank you! can I ask what that first line _t is doing, escpecially the "chart", [chart] part?