Forum Discussion
Calculated Measures - Grand Total Frozen (SSAS OLAP Cube / Live Connection)
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.
2 Replies
v-chuncz-msftCommunity Support
You may take a look at the link below.
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.
