Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count if true

How do you count the number 100 in a particular column Column a 0 100 100 0 100 There are 3 numbers
COUNT
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Anonymous ,

    Try this.

    Count = CALCULATE(COUNTAX('Table','Table'[Column1] = 100),'Table'[Column1] = 100)

     

    or

    Count 2 = Calculate (COUNT('Table'[Column1]),'Table'[Column1]=100)

     

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous ,

Try this.

Count = CALCULATE(COUNTAX('Table','Table'[Column1] = 100),'Table'[Column1] = 100)

 

or

Count 2 = Calculate (COUNT('Table'[Column1]),'Table'[Column1]=100)

 

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel