Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |