cancel
Showing results for
Did you mean:
Frequent Visitor

## 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

Accepted Solutions
Super User

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

@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
)
)```
4 REPLIES 4
Super User

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

@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
)
)```
Frequent Visitor

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

Thanks a lot Zubair, its working

Frequent Visitor

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

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.

Super User

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

@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
)
)```