Cumulative Line disappears in "Percent of grand total mode"

[Bosu]

Hi All!

I have been struggling with this issue for two days now and decided to get a helping hand.

The issue is that one of three cumulative lines disappears on my Line and Clustered Column chart after changing the "Show as value" parameter to "Percent of grand total" mode. The remaining lines don't have that issue. 

I tried fixing this with a workaround, creating a separate table to calculate the percentages manually, but when I did that, the total of one of the series did not add up to 100%! My mind is fried at this point. Maybe any of you will have an idea of where I could have made a mistake.

Here are the DAXes for my lines for context. The last one is the troublesome one.

Baseline % Planned = 

CALCULATE(
	SUM(DAX_ManDays[ManDays_All_BL]),
	FILTER(
		ALLSELECTED(DAX_ManDays[Calendar days (bins)]),
		ISONORAFTER(DAX_ManDays[Calendar days (bins)], MAX(DAX_ManDays[Calendar days (bins)]), DESC)
	)
)

Forecast Duration % = 
	CALCULATE(
		IF(
			MAX(DAX_ManDays[Calendar days]) >= MAX(DAX_ManDays[Schedule Update Date]),
			SUM(DAX_ManDays[ManDays_All_New])
			),           
                FILTER(
                    ALLSELECTED(DAX_ManDays[Calendar days (bins)]),
                    ISONORAFTER(DAX_ManDays[Calendar days (bins)], MAX(DAX_ManDays[Calendar days (bins)]), DESC)
                )
            )

Earned Duration % = 
	CALCULATE(
		IF(
			MAX(DAX_ManDays[Calendar days (bins)]) < MAX(DAX_ManDays[Schedule Update Date]),
			SUM(DAX_ManDays[ManDays_All_New])
			),           
                FILTER(
                    ALLSELECTED(DAX_ManDays[Calendar days (bins)]),
                    ISONORAFTER(DAX_ManDays[Calendar days (bins)], MAX(DAX_ManDays[Calendar days (bins)]), DESC)
                )
            )

 

Also, image of the graph with the Percent of the grand total turned off for all the lines - working well, and with the Percent of the grand total turned on - missing the first line.

[Bosu]

Thank you! That worked!

I still need to learn a lot about DAX. I'm not sure if I encountered a bug or if I did something wrong. 

FYI, I performed a minor modification from 

% Measure 3= DIVIDE([Earned Duration %],[Total Measure 3],0)

To

% Measure 3= DIVIDE([Earned Duration %],[Total Measure 2],0)

But that's due to my data structure. 

[v-tangjie-msft · Accepted solution]

Hi @Bosu ,

You can create measures. Then place [% measure 1], [% measure 2] and [% measure 3] on the visual object.

Total Measure 1= CALCULATE([Baseline % Planned],ALL('DAX_ManDays'))

Total Measure 2= CALCULATE([Forecast Duration %],ALL('DAX_ManDays'))

Total Measure 3= CALCULATE([Earned Duration %],ALL('DAX_ManDays'))

% Measure 1= DIVIDE([Baseline % Planned],[Total Measure 1],0)

% Measure 2= DIVIDE([Forecast Duration %],[Total Measure 2],0)

% Measure 3= DIVIDE([Earned Duration %],[Total Measure 3],0)

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.