topic Re: Want to find the number of Suppliers with Average Rating between 4 and 5 in Desktop
https://community.powerbi.com/t5/Desktop/Want-to-find-the-number-of-Suppliers-with-Average-Rating-between/m-p/421744#M193919
<P>Thanks a lot Zubair, its working</P>Mon, 21 May 2018 10:49:41 GMTDebasish10112018-05-21T10:49:41ZWant to find the number of Suppliers with Average Rating between 4 and 5
https://community.powerbi.com/t5/Desktop/Want-to-find-the-number-of-Suppliers-with-Average-Rating-between/m-p/421636#M193859
<P>Hi</P><P> </P><P>I have data in the following format:</P><P> </P><P>Supplier ID Rating Value</P><P>------------- ------------------</P><P>123 4</P><P>123<SPAN> 5</SPAN></P><P>234<SPAN> 1</SPAN></P><P>567<SPAN> 2</SPAN></P><P>345<SPAN> 4</SPAN></P><P>234<SPAN> 4</SPAN></P><P> </P><P> </P><P><SPAN>I want to find the count of suppliers whose average rating is between 4 and 5.</SPAN></P><P> </P><P><SPAN>Average rating of a supplier = Sum of Ratings received by the supplier/Total no. of ratings received by the supplier</SPAN></P>Mon, 21 May 2018 08:25:06 GMThttps://community.powerbi.com/t5/Desktop/Want-to-find-the-number-of-Suppliers-with-Average-Rating-between/m-p/421636#M193859Debasish10112018-05-21T08:25:06ZRe: Want to find the number of Suppliers with Average Rating between 4 and 5
https://community.powerbi.com/t5/Desktop/Want-to-find-the-number-of-Suppliers-with-Average-Rating-between/m-p/421659#M193873
<P><LI-USER uid="65330"></LI-USER></P><P> </P><P>Try thsi MEASURE</P><P> </P><PRE>Count_of_Suppliers =
COUNTROWS (
FILTER (
ALLSELECTED ( Table1[Supplier ID] ),
CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) >= 4
&& CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) <= 5
)
)</PRE>Mon, 21 May 2018 08:57:24 GMThttps://community.powerbi.com/t5/Desktop/Want-to-find-the-number-of-Suppliers-with-Average-Rating-between/m-p/421659#M193873Zubair_Muhammad2018-05-21T08:57:24ZRe: Want to find the number of Suppliers with Average Rating between 4 and 5
https://community.powerbi.com/t5/Desktop/Want-to-find-the-number-of-Suppliers-with-Average-Rating-between/m-p/421744#M193919
<P>Thanks a lot Zubair, its working</P>Mon, 21 May 2018 10:49:41 GMThttps://community.powerbi.com/t5/Desktop/Want-to-find-the-number-of-Suppliers-with-Average-Rating-between/m-p/421744#M193919Debasish10112018-05-21T10:49:41ZRe: Want to find the number of Suppliers with Average Rating between 4 and 5
https://community.powerbi.com/t5/Desktop/Want-to-find-the-number-of-Suppliers-with-Average-Rating-between/m-p/421753#M193922
<P><LI-USER uid="42973"></LI-USER></P><P> </P><P>Can we help me with another condition please.</P><P> </P><P>How to calculate the <SPAN>number of Suppliers with Average Rating between 4 and 5 but will only consider the Suppliers who have got more than one rating count.</SPAN></P>Mon, 21 May 2018 11:13:56 GMThttps://community.powerbi.com/t5/Desktop/Want-to-find-the-number-of-Suppliers-with-Average-Rating-between/m-p/421753#M193922Debasish10112018-05-21T11:13:56ZRe: Want to find the number of Suppliers with Average Rating between 4 and 5
https://community.powerbi.com/t5/Desktop/Want-to-find-the-number-of-Suppliers-with-Average-Rating-between/m-p/421774#M193929
<P><LI-USER uid="65330"></LI-USER></P><P> </P><P>You can add another condition as follows</P><P> </P><PRE>Count Of Suppliers =
COUNTROWS (
FILTER (
ALLSELECTED ( Table1[Supplier ID] ),
CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) >= 4
&& CALCULATE ( AVERAGE ( Table1[Rating Value] ) ) <= 5
&& <STRONG><FONT color="#FF0000">CALCULATE ( COUNT ( Table1[Rating Value] ) ) > 1</FONT></STRONG>
)
)</PRE>Mon, 21 May 2018 11:59:20 GMThttps://community.powerbi.com/t5/Desktop/Want-to-find-the-number-of-Suppliers-with-Average-Rating-between/m-p/421774#M193929Zubair_Muhammad2018-05-21T11:59:20Z