Hi,
I'm experiencing a behaviour of a very simple CALCULATE statement which I can't manage to get my head around .
I summarized the issue is following screenshot. Bascially 2 questions pop up :
1. Why do I see a full table when using the FcstVersion2 measure vs using FcstVersion1 measure (only showing 1 line)? The formula seems identical to me, I'm just using a different column to sort the Calendar table.
2. When visualizing measure FcstVersion1, I get a different result when showing it in a Matrix visual in PowerBI Desktop versus when showing it in an Excel Pivot table (connected to the data model of the same PBI file of course).
Would be very greatful to get help / an explanation on this one!
Peter
Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
