Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Try thsi MEASURE
Count_of_Suppliers = COUNTROWS ( FILTER ( ALLSELECTED ( Table1[Supplier ID] ), CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) >= 4 && CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) <= 5 ) )
Try thsi MEASURE
Count_of_Suppliers = COUNTROWS ( FILTER ( ALLSELECTED ( Table1[Supplier ID] ), CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) >= 4 && CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) <= 5 ) )
Thanks a lot Zubair, its working
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.
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 ) )
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |