How to count rows from a binary category

[Anonymous]

Hello, 

I am trying to create a measure that aggregate the sla_ttr_passed =1 from a binary category.

It is possible to do that? 

Many thanks

Rocio

[v-yalanwu-msft · Accepted solution]

Hi @Anonymous  ,

You also could create measure by the following formula:

count1 = COUNTX(FILTER('Table',[sla_ttr_passed]=1),[sla_ttr_passed])

or

count2 = CALCULATE(COUNT([sla_ttr_passed]),'Table'[sla_ttr_passed]=1)

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Check if one the three measure can work

countrows(filter(Table,[sla_ttr_passed]))

or

countrows(filter(Table,[sla_ttr_passed] =1))

or

countrows(filter(Table,[sla_ttr_passed] =true() ))