DAX Help - Count row category type

[agd50]

I feel this should be simple, what am I missing here? Count any that has the value of 'True'

[Ritaf1983 · Accepted solution]

Hi @agd50  you should use "calculate" to give a filter context.
If your due column's data type is boolean the right formula :

test = CALCULATE(COUNT('Table'[cat]),'Table'[due]=TRUE())

in the case it is a string :

test text = CALCULATE(count('Table'[cat]), 'Table'[due string]= "True")

Link to a sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[agd50]

Wonderful job, well done!

[Ritaf1983]

Glad to help 🙂