Forum Discussion
Jonnokc
10 years agoFrequent Visitor
DAX function to count specific text values from a column
Hello, How I am trying to total a specific value from a column. The column contains multipe values and I want to know the count for a specific value. The COUNTA function just totals every bla...
- 10 years ago
You need to write a formula like which will count all the rows containing "This Value"
CountValues = CALCULATE ( COUNTROWS ( TableName ); TableName[ColumnName] = " This Value " )
konstantinos
10 years agoMemorable Member
You need to write a formula like which will count all the rows containing "This Value"
CountValues = CALCULATE ( COUNTROWS ( TableName ); TableName[ColumnName] = " This Value " )
rgreener
6 years agoFrequent Visitor
how would I utilized this formula to look for multiple values in the same column? using this example I would want to count rows that have "This Value" "That Value" "It Value" etc. Thank you so much