topic Re: Percentage of total in DAX Commands and Tips

Percentage of total

SJHA — Wed, 23 Sep 2020 09:17:49 GMT

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] ) )

)

Re: Percentage of total

amitchandak — Wed, 23 Sep 2020 09:20:42 GMT

SJHA , try ALLSelected

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

Re: Percentage of total

SJHA — Wed, 23 Sep 2020 09:42:02 GMT

amitchandak

It works! Thank you once again 😀