Percentage of grand total not calculating as expected?

[Anonymous]

Hi,

I want to calculate the Y axis to show the % of the toal: 3.35m.

However, when I click 'Show value as percentage of grand total', 

It is showing the % of 350m, rather than 3.5m.....

Could some please advise? Thanks.

[amitchandak]

@Anonymous , You need to create a measure like

Divide([Measure], 400000)

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Hi,  I have added sample data, thanks.

[mwegener]

Hi @Anonymous ,

can you provide a sample file?

The grand total will be the sum of all values without considering the X axis.

[Anonymous]

Hi, I have added the sample data in a table in the question. Thanks.

[mwegener · Accepted solution]

Hi @Anonymous ,

try this

GT% WAULT Income to Break = 
VAR _MAX = CALCULATE(MAX('Waterfall (New)'[WAULT Income to Break]), ALLSELECTED('Waterfall (New)' ))
RETURN
DIVIDE(MAX('Waterfall (New)'[WAULT Income to Break]),_MAX)

GT% WAULT Income to Expiry = 
VAR _MAX = CALCULATE(MAX('Waterfall (New)'[WAULT Income to Expiry]), ALLSELECTED('Waterfall (New)' ))
RETURN
DIVIDE(MAX('Waterfall (New)'[WAULT Income to Expiry]),_MAX)