https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Normalization-of-Sales-values-to-use-as-ranking/m-p/1135891#M16930 <P>After developing a ranking list based on percentile of Net sales with i faced some issues:</P><P>i have a lot of projects with 0 sales that will be ranked relatively high due to the percentile formula.</P><P>What i would like to try now is to rank the projects Sales based on a simple normalization step (eg. if the maximum net sales is $3000 and a project has a sales of $1500, this should return a rank from 5-1. &nbsp; 5 for projects with $3000 and 1 for projects with $0 sales.</P><P>any help is highly apreciated.</P><P>thanks a lot</P><P>file bellow</P><P><A href="https://drive.google.com/file/d/1bHSi5Y3uWejmBMownMDI8ry-EL0l9h0n/view?usp=sharing" target="_self">PBIX file</A>&nbsp;</P> Tue, 02 Jun 2020 12:51:18 GMT Vandergledison 2020-06-02T12:51:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Normalization-of-Sales-values-to-use-as-ranking/m-p/1135891#M16930 <P>After developing a ranking list based on percentile of Net sales with i faced some issues:</P><P>i have a lot of projects with 0 sales that will be ranked relatively high due to the percentile formula.</P><P>What i would like to try now is to rank the projects Sales based on a simple normalization step (eg. if the maximum net sales is $3000 and a project has a sales of $1500, this should return a rank from 5-1. &nbsp; 5 for projects with $3000 and 1 for projects with $0 sales.</P><P>any help is highly apreciated.</P><P>thanks a lot</P><P>file bellow</P><P><A href="https://drive.google.com/file/d/1bHSi5Y3uWejmBMownMDI8ry-EL0l9h0n/view?usp=sharing" target="_self">PBIX file</A>&nbsp;</P> Tue, 02 Jun 2020 12:51:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Normalization-of-Sales-values-to-use-as-ranking/m-p/1135891#M16930 Vandergledison 2020-06-02T12:51:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Normalization-of-Sales-values-to-use-as-ranking/m-p/1136996#M16976 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="225598" data-lia-user-login="Vandergledison" class="lia-mention lia-mention-user">Vandergledison</a>&nbsp;,</P><P>&nbsp;</P><P>&nbsp;</P><P>You can use binning techinque through Calculated Columns.</P><P>&nbsp;</P><P>Attached link to file.</P><P>&nbsp;</P><P><A href="https://drive.google.com/file/d/1znvLF_QhCuEJJ0J9K_VBI66m-Pdeo3Ik/view?usp=sharing" target="_blank">https://drive.google.com/file/d/1znvLF_QhCuEJJ0J9K_VBI66m-Pdeo3Ik/view?usp=sharing</A></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Regards,</P><P>Harsh Nathani</P><P>&nbsp;</P><P><STRONG>Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)</STRONG></P> Tue, 02 Jun 2020 20:00:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Normalization-of-Sales-values-to-use-as-ranking/m-p/1136996#M16976 Anonymous 2020-06-02T20:00:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Normalization-of-Sales-values-to-use-as-ranking/m-p/1142013#M17113 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="225598" data-lia-user-login="Vandergledison" class="lia-mention lia-mention-user">Vandergledison</a>&nbsp;,</P><P>&nbsp;</P><P>&nbsp;</P><P><A href="https://drive.google.com/file/d/1qCH6XD_jR88CEyzIgEeQx0ffo5yv3Rk_/view?usp=sharing" target="_blank">https://drive.google.com/file/d/1qCH6XD_jR88CEyzIgEeQx0ffo5yv3Rk_/view?usp=sharing</A></P><P>&nbsp;</P><P>Link to the file with dynamic ranking.</P><P>&nbsp;</P><P>Regards,</P><P>Harsh Nathani</P> Thu, 04 Jun 2020 13:39:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Normalization-of-Sales-values-to-use-as-ranking/m-p/1142013#M17113 Anonymous 2020-06-04T13:39:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Normalization-of-Sales-values-to-use-as-ranking/m-p/1142092#M17120 <P>Yes Sir! perfect! thanks a lot</P> Thu, 04 Jun 2020 14:17:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Normalization-of-Sales-values-to-use-as-ranking/m-p/1142092#M17120 Vandergledison 2020-06-04T14:17:58Z