DAX function

Like (1) Share

Report

Posted on 24 Sep 2024 12:47:38 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)

ArwaAldoudOmer 4 on 01 Oct 2024 at 18:02:53

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.