Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Count by Group by

Hi, I need some help with a calculated column.   Following are the details: client_id survey_id comment_id comment_text Count of Comments 123 234782 34835 kjsysdihskf 3 123 23478...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous,

AFAIK, most of calculation DAX functions has been limited to use in direct query mode. You can use measure formula instead.

Measure =
CALCULATE (
    COUNTROWS ( VALUES ( 'Table'[comment_id] ) ),
    ALLSELECTED ( 'Table' ),
    VALUES ( 'Table'[client_id] ),
    VALUES ( 'Table'[survey_id] )
)

Regards,

Xiaoxin Sheng