DAX function

(1) Share

Report

Posted on by TR-24091232-0

Unable to create a query to find out the occurrence of the specific number in a column like a column containing all possible combinations of 1- 5 star ratings, so need to count only how many times 5 occurs in a column. Showing error when put the query like Calculation 1 = COUNT([Count of FEEDBACK_POINT]=5)

Categories:

General Comment

All responses (1)

Answers (0)

ArwaAdoudOmer 4 on at

Like (0)

Report
DAX function

To count how many times a specific number (like 5) appears in a column, the formula you're using needs a slight adjustment. Instead of using COUNT, you should use CALCULATE with a FILTER condition

Calculation1 = CALCULATE(COUNTROWS(RateTableName), RateTableName[FEEDBACK_POINT] = 5)

RateTableName: The Name of your Table

FEEDBACK_POINT: Column containing ratings from 1 to 5 stars

CALCULATE: Modifies the context in which the data is evaluated.

COUNTROWS: Counts the rows in the table that meet the condition.

RateTableName[FEEDBACK_POINT] = 5: to filters only the rows where the FEEDBACK_POINT equals 5.