cancel
Showing results for
Did you mean: 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  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

4 REPLIES 4  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 New Member

Thanks a lot Zubair, its working New Member

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.  Community Champion

@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 Announcements #### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories. #### Power BI Dev Camp - September 30th, 2021  