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

[Debasish1011]

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

[Zubair_Muhammad · Accepted solution]

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

[Debasish1011]

Thanks a lot Zubair, its working

[Debasish1011]

@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.

[Zubair_Muhammad]

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