News and Announcements icon

Power Platform CommunityForums Power Apps - Power Query DAX function

Power Apps - Power Query

Unanswered

DAX function

(1) Share

Report

Report

Posted on by TR-24091232-0

2

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 Img

All responses (1)

Answers Img

Answers (0)

ArwaAldoudOmer 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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Apps

#1

WarrenBelz 791 Most Valuable Professional

#2

MS.Ragavendar 410

#3

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans