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
Fabric Monthly Update - November 2025
Check out the November 2025 Fabric update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
