Forum Discussion
Monthly averages - Calculated column - Aggregation
Hi Cro-Magnon,
To fix this, you can use an below measure that calculates the percentage correctly by summing up the values at the level you want.
Dax Measure :STD_Percentage_XX = DIVIDE([TotalProducts_XX], [STD_Products_XX], 0 )
the expected output as below :
This measure works with the aggregated totals instead of individual row context, providing the correct percentage of standard products.If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Hi Cro-Magnon,
To fix this, you can use an below measure that calculates the percentage correctly by summing up the values at the level you want.
Dax Measure :
STD_Percentage_XX =
DIVIDE([TotalProducts_XX],
[STD_Products_XX],
0
)
the expected output as below :
This measure works with the aggregated totals instead of individual row context, providing the correct percentage of standard products.
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Hi Cro-Magnon ,
If our response addressed your query, please mark it as Accepted Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
Hi Cro-Magnon ,
Has your issue been resolved? If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!Hi Cro-Magnon ,
If our response addressed your query, please mark it as Accepted Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!