Percentage of total

[SJHA]

Hi,

I'm trying to calculate the percentage of the total amount but it doesn't give me the correct percentage (close to correct).

% of Grand Total =

DIVIDE (

SUM ( tidsregistrering[Amount] ),

CALCULATE ( SUM ( 'tidsregistrering'[Amount] ), ALL ( 'tidsregistrering'[subActivityTitle] ) )

)

[amitchandak · Accepted solution]

@SJHA , try ALLSelected 

% of Grand Total =
DIVIDE (
SUM ( tidsregistrering[Amount] ),
CALCULATE ( SUM ( 'tidsregistrering'[Amount] ), ALLSelected ( 'tidsregistrering'[subActivityTitle] ) )
)

[SJHA]

@amitchandak 

It works! Thank you once again 😀