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.
Hi,
I have made calculated measures to show the cumulative values of two columns (Actuals and Target). The formula works the same for both except they use a different column from the Entries table (Actual and Target respectively). So the cumulative actual formula looks as follows
Cumulative Actual = CALCULATE( SUM (Entries[Actual]); FILTER(ALL(Entries); Entries[WeekNum]<=MAX(Entries[WeekNum]) ) )
And this shows me the correct total of the cumulatives when comparing this total value of the graph with the gauge meter on this page of the report (182.37m).
However, when using the slicer on the left (or selecting items in the matrix tables for that matter), the graph does not display the correct value anymore. This can be concluded by comparing the gauge meter actual value (1m) to the graph actual value (143.38m).
The visuals have interaction on as can be seen in the screenshots and the gauge meter + table values are correct this way. I feel as I am overlooking a simple thing but can't figure this out. How can I get my graph (with the calculated cumulative measure) to respond to this drilldown as expected?
EDIT: forgot screenshots
Solved! Go to Solution.
HI @Joost
What happens when you try this small tweak?
Cumulative Actual = CALCULATE( SUM (Entries[Actual]); FILTER(ALLSELECTED(Entries); Entries[WeekNum]<=MAX(Entries[WeekNum]) ) )
HI @Joost
What happens when you try this small tweak?
Cumulative Actual = CALCULATE( SUM (Entries[Actual]); FILTER(ALLSELECTED(Entries); Entries[WeekNum]<=MAX(Entries[WeekNum]) ) )
Thank you Phil! That did the trick. Learning something new everyday.
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |