cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors