Forum Discussion

agd50's avatar
agd50
Helper V
3 years ago
Solved

DAX Help - Count row category type

I feel this should be simple, what am I missing here? Count any that has the value of 'True'  
  • Ritaf1983's avatar
    3 years ago

    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