Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SJHA
Helper I
Helper I

Percentage of total

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] ) )
)
 
2020-09-23 09_51_07-Window.png
 
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@SJHA , try ALLSelected 

 

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@SJHA , try ALLSelected 

 

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

@amitchandak 

It works! Thank you once again 😀

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.