https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weighted-average-with-redistribution-of-weights/m-p/3048126#M104868 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="505899" data-lia-user-login="GNOliveira" class="lia-mention lia-mention-user">GNOliveira</a>&nbsp;</P><P>this is helpful</P><P><A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/m-p/1626726#M32906" target="_blank">https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/m-p/1626726#M32906</A></P> Sat, 28 Jan 2023 00:43:08 GMT FreemanZ 2023-01-28T00:43:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weighted-average-with-redistribution-of-weights/m-p/3048038#M104862 <P>Weighted average with redistribution of weights<BR />Example:<BR />I have 4 indicators. Each with its respective weight.<BR />IND1 and P1 = 10<BR />IND2 and P2 = 20<BR />IND3 and P3 = 30<BR />IND4 AND P4 = 40</P><P>If I don't get the result for a day or month, the weighted average will equally redistribute the weight to the others and perform the weighted average.</P><P>So, if I don't have the IND3, the P3 = 30 will be redistributed equally to the others. Therefore, P1 becomes weight 20, P2 weight 30 and P4 weight 50.</P><P>Once this is done, it calculates the weighted average with the 3 indicators.</P><P>&nbsp;</P> Fri, 27 Jan 2023 22:34:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weighted-average-with-redistribution-of-weights/m-p/3048038#M104862 GNOliveira 2023-01-27T22:34:10Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weighted-average-with-redistribution-of-weights/m-p/3048126#M104868 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="505899" data-lia-user-login="GNOliveira" class="lia-mention lia-mention-user">GNOliveira</a>&nbsp;</P><P>this is helpful</P><P><A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/m-p/1626726#M32906" target="_blank">https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/m-p/1626726#M32906</A></P> Sat, 28 Jan 2023 00:43:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Weighted-average-with-redistribution-of-weights/m-p/3048126#M104868 FreemanZ 2023-01-28T00:43:08Z