Forum Discussion
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
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
1 Reply
- Nathaniel_C
Community Champion
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