Skip to main content

Notifications

Power Apps - Power Query
Unanswered

DAX function

Like (1) ShareShare
ReportReport
Posted on 24 Sep 2024 12:47:38 by 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:
  • ArwaAdoudOmer Profile Picture
    ArwaAdoudOmer 4 on 01 Oct 2024 at 18:02:53
    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.
     
     

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.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,238

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,290

Leaderboard

Featured topics

Loading complete