Calculated Measures - Grand Total Frozen (SSAS OLAP Cube / Live Connection)

[thiagoreale]

Hello!

I have 2 measures (screen 1), with the same value when there is no filters.

On the LEFT, the regular measure that comes from the database field. On the RIGHT, a calculated measure. The formula for the calculated measure is equal to the regular measure (sreen 2) - I did on porpouse to isolate the problem, so it is the simplest calculated measure possible.

When I apply a filter (screen 3) on PowerBI (desktop or web), it filters the members but does not filter the total for the calculated measure.

OBS: If I filter other Dimensions (region, etc), it works. But does not work for Time dimension. 

What am I missing? 

Thanks in advance.

[v-chuncz-msft]

@thiagoreale,

You may take a look at the link below.

https://social.technet.microsoft.com/wiki/contents/articles/51735.dynamic-named-sets-with-power-bi.a...

[thiagoreale]

Hey @v-chuncz-msft, thanks for the reply.

Since I'm not used to Dynamic Sets, I tried to create the dynamic set with all dates and use in the calculation like here:

CREATE DYNAMIC SET CURRENTCUBE.[Selected Date]
 AS { EXISTING [DIM - Time].[Hierarchy].[Date].MEMBERS } ;

and in the simple calculation:

CREATE MEMBER CURRENTCUBE.[Measures].[VL Charge € - Pro Rata]
AS 

SUM( [Selected Dates] , [Measures].[VL Charge € - Pro Rata HDN] ),

VISIBLE = 1;       

But... it worked for the grand total but if I get the time dimension, I got some "cross-join like" results.