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'

 

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    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



3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    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