cancel
Showing results for 
Search instead for 
Did you mean: 
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
    )
)
Regards
Zubair

Please try my custom visuals


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
    )
)
Regards
Zubair

Please try my custom visuals


View solution in original post

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
    )
)
Regards
Zubair

Please try my custom visuals


Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors