Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Debasish1011
New Member

Want to find the number of Suppliers with Average Rating between 4 and 5

Hi

 

I have data in the following format:

 

Supplier ID            Rating Value

-------------          ------------------

123                            4

123                            5

234                            1

567                            2

345                            4

234                            4

 

 

I want to find the count of suppliers whose average rating is between 4 and 5.

 

Average rating of a supplier = Sum of Ratings received by the supplier/Total no. of ratings received by the supplier

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

@Debasish1011

 

Try thsi MEASURE

 

Count_of_Suppliers =
COUNTROWS (
    FILTER (
        ALLSELECTED ( Table1[Supplier ID] ),
        CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) >= 4
            && CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) <= 5
    )
)

View solution in original post

4 REPLIES 4
Zubair_Muhammad
Community Champion
Community Champion

@Debasish1011

 

Try thsi MEASURE

 

Count_of_Suppliers =
COUNTROWS (
    FILTER (
        ALLSELECTED ( Table1[Supplier ID] ),
        CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) >= 4
            && CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) <= 5
    )
)

Thanks a lot Zubair, its working

@Zubair_Muhammad

 

Can we help me with another condition please.

 

How to calculate the number of Suppliers with Average Rating between 4 and 5 but will only consider the Suppliers who have got more than one rating count.

@Debasish1011

 

You can add another condition as follows

 

Count Of Suppliers =
COUNTROWS (
    FILTER (
        ALLSELECTED ( Table1[Supplier ID] ),
        CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) >= 4
            && CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) <= 5
            && CALCULATE ( COUNT ( Table1[Rating Value] ) ) > 1
    )
)

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors