Forum Discussion
how to write measure correctly
Hello VizCraft,
Thanks for posting your query and welcome to the Microsoft Fabric Community.I’ve reviewed your scenario in detail and reproduced it in Power BI. Your goal was to distribute the remaining quantity (Restmenge) based on each size’s share of the total forecast, and the logic works as expected using the correct DAX measures.
What I Did:
- Recreated your sample data (Article Size + Forecast Quantity).
- Calculated:
- Total Forecast Quantity
- Restmenge = MOQ - Total Forecast
- Prozent von Gesamtsumme using proper context removal
- Verteilung as the proportional share of remaining quantity
- Used DAX context correction to ensure accurate row-level allocation.
The key fix was adjusting the DAX to ensure that both [Restmenge] and the percentage calculation were not affected by row filters. For your reference, I’ve attached a .pbix file please feel free to download and explore the file.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Community SupportHello VizCraft,
Thanks for posting your query and welcome to the Microsoft Fabric Community.
I’ve reviewed your scenario in detail and reproduced it in Power BI. Your goal was to distribute the remaining quantity (Restmenge) based on each size’s share of the total forecast, and the logic works as expected using the correct DAX measures.
What I Did:
- Recreated your sample data (Article Size + Forecast Quantity).
- Calculated:
- Total Forecast Quantity
- Restmenge = MOQ - Total Forecast
- Prozent von Gesamtsumme using proper context removal
- Verteilung as the proportional share of remaining quantity
- Used DAX context correction to ensure accurate row-level allocation.
The key fix was adjusting the DAX to ensure that both [Restmenge] and the percentage calculation were not affected by row filters. For your reference, I’ve attached a .pbix file please feel free to download and explore the file.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Community SupportHello VizCraft,
I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.
If your question has been answered, please “Accept as Solution” and Give “Kudos” so others with similar issues can easily find the resolution.
Thank you.