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
gkakun
Helper III
Helper III

Grouping and calculate % of total

Hi all,

 

I have an issue that I couldnt find answer for. 

I have this table and Im trying to calculate the amount based on the relative duration.

For example, ?for the first row- 18/103*40K=6990

 

gkakun_0-1679909511615.png

 

 

 

Thanks for your help! 

7 REPLIES 7
Arul
Super User
Super User

@gkakun ,

Is Activity Duration a direct column or a measure?
Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Hi,

Its lookup column from different table, using related function. PO# is the key  

@gkakun ,

 try this measure,

Activity calculation = 
VAR _activityDuration = SUM(Table[ Activity Duration])
VAR _allActivityDuration = CALCULATE(
    SUM(Table[ Activity Duration]),ALL(Table))
VAR _result = DIVIDE(_activityDuration ,_allActivityDuration )*40000
RETURN _result 

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Thanks a lot for your help.

 

This is like the measure looks like, it should provide 40K eventually, but its ot the case

 

gkakun_0-1679988396700.png

 

and of course, the 40K should be taken from the SC amount, since its changing between the POs 

@gkakun ,

then use SC amount in the measure.

Activity calculation = 
VAR _activityDuration = SUM(Table[ Activity Duration])
VAR _allActivityDuration = CALCULATE(
    SUM(Table[ Activity Duration]),ALL(Table))
VAR _result = DIVIDE(_activityDuration ,_allActivityDuration )*[SC Count]
RETURN _result 

Thanks,

Arul





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Thanks a lot! unfortunately its not working 😞

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.