Forum Discussion

Del235's avatar
Del235
Helper III
3 years ago

Count not calculating correctly

I am trying to count text in a column but I'm getting incorrect values.  Example:  I have two columns    Visit Date Attendance Promoter-Detractor 7/9/2023 0:00 Promoter 7/9/2023 0:00 Pr...
Del235's avatar
Del235
Helper III
3 years ago

Same result

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

You're using a DAX measure? That tested successfully for me...

 

Count of Promoter-Detractor for Promoter = 
COUNTROWS(
    FILTER('CUSTOMER_FEEDBACK_TABLE',
    'CUSTOMER_FEEDBACK_TABLE'[Promoter-Detractor] = "Promoter"
    )
)