Forum Discussion

Jonnokc's avatar
Jonnokc
Frequent Visitor
10 years ago
Solved

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...
  • konstantinos's avatar
    konstantinos
    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 " )
dsilveira's avatar
dsilveira
Advocate I
9 years ago

 Hi karthik

thanks for your comments. I was reading, but in case I need count how often all the rows repeat (of course I can't specificate the world) For example:

 

Table:

Jim

Tom

Tom

Mary

Jim

Jim

I would like to Return:

Jim      3

Tom    2

Tom    2

Mary   1

Jim      3

Jim      3

 

Thanks you very much!

chauhai's avatar
chauhai
Regular Visitor
8 years ago

Hi,

 

Were you ble to resolve the issue? I am trying to replicate the countif functionality of excel in power BI.