% of Total - not working

[julrua]

Dear all, 

I need to obtain the column ConsumedEvo% in the second table. 

To do so, I have done the following measure 

Consumed(%) test = DIVIDE([Total YTD Actual Amount],SUM('Business management (customer HUB)'[Offer amount approved]))

However, it does not display the % row by row. 

Can you help me on this please? 

Thank you in advance. 

Kind regards, 

[amitchandak]

@julrua , Try

Consumed(%) test = DIVIDE([Total YTD Actual Amount],calculate(SUM('Business management (customer HUB)'[Offer amount approved]),allselected()))

[julrua]

@amitchandak thank you 

Is it possible to have the cumulative? Instead of 6,05% it will be 6,88%?