Calculations with measures return odd results

Hi BieBel,

Thanks for reaching out to the Microsoft fabric community forum. Thank you amitchandak  for your helpful ressponse.

In the earlier formula, "_days" is not an actual column from your model it serves as a temporary column name (alias) within the SUMMARIZE function. This alias stores the [Netto_Workdays_per_month] result for each group before aggregation. You can rename it to something clearer, such as "NetDays".

Here’s the adjusted version:

Total days =
SUMX (
   SUMMARIZE (
      'Closed_Tickets_Filtered',
      'Closed_Tickets_Filtered'[WR_ID],
      'Closed_Tickets_Filtered'[MONTHCOMPLETED],
      'Calendar'[Month],
      "NetDays", [Netto_Workdays_per_month]
   ),
   [NetDays]
)

By doing this, [Netto_Workdays_per_month] is calculated at the correct month/region level first and then aggregated. This resolves the issue of unexpected productivity results.

Finally, your Productivity measure can be written as:

Productivity =
DIVIDE ( [Closed_Tickets_per_Month], [Total days] )

This ensures the numerator and denominator are aligned at the same level of detail, giving you the expected outcome.

If the above given solution doesn't meet your requirment, please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Want faster answers? How to Get Your Question Answered Quickly - Microsoft Fabric Community

Hope this helps. Please feel free to reach out for any further questions.

Thank you .