DAX - CALCULATE behaviour- PBI matrix vs excel piv...

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