We have a calculation in a cube that sums up the difference of 2 measures at a specific level using intersect. In Power BI if I drag that hierarchy in at a higher level it for some reasons only returns 1 record and filters the measure. Even if I drag in the level of the hierarchy being used in the intersect it's still only a single value for the hierarchy. I would expect to see the calculation as though it didn't have the intersect. That is what I see in excel where it behaves as expected. Power BI does not show the same thing as excel. It's like Power BI is filtering behind the scene. If I drag in the lowest level of the hierarchy that is being used in the intersect, it works as expected.
MDX in the cube:
CREATE DYNAMIC SET CURRENTCUBE.[Existing Groupings] AS existing [Product].[Product Hierarchy].[Material Grouping];
CREATE MEMBER CURRENTCUBE.[Measures].[Forecast Comparison] AS sum( INTERSECT( descendants([Product].[Product Hierarchy].CurrentMember ,[Product].[Product Hierarchy].[Material Group], SELF), [Existing Groupings]), abs([Measures].[Sales] - [Measures].[Forecast]) ),