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)
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
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.