Grouping and calculate % of total

[gkakun]

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

Thanks for your help! 

[Arul]

@gkakun ,

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

Arul

[gkakun]

Hi,

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

[Arul]

@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

[gkakun]

Thanks a lot for your help.

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

[gkakun]

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

[Arul]

@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

[gkakun]

Thanks a lot! unfortunately its not working 😞