Sum of Daliy Progress base from Multiple Column

[AllanBerces]

Hi Good day,

Can anyone pls need assistance on how can i reflect the sum of Daily Earned from table 1 to table 2  base from multiple column (Asset, Shutdown move, subcon and Project name)

Table 1

Table 2

Final Result (Jun 28-29)

https://drive.google.com/file/d/1uZ5saMtEsAf3OOgvFKZ-5HR6smW8tmV8/view?usp=sharing

Thank you

[rajendraongole1]

Hi @AllanBerces  Can you try the below measure 

DailyEarned =

CALCULATE(

    SUM('T1'[Daily Earned]),

    FILTER(

        'T1',

        'T1'[Asset] = RELATED('T2'[Asset]) &&

        'T1'[Shutdown Move] =RELATED( 'T2'[Shutdown Move] )&&

        'T1'[Subcon] = RELATED('T2'[Subcon] )

    )

)

if you want to compare the date plan and progress plan also we can add in above measure.

try it. Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[AllanBerces]

HI @rajendraongole1 thank you for you reply, but its not working. the two table are connected to Dimdate table.

Thank you

[danextian]

hi @AllanBerces ,

Data is inacessible:

[AllanBerces]

Hi @danextian pls refer below link

TA_REPORT_TEST_ver.pbix

Thank you

[danextian · Accepted solution]

Try this calc column

Daily Earned = 
CALCULATE (
    SUM ( 'JC Daily Progress'[Daily Earned] ),
    FILTER (
        ALL ( 'JC Daily Progress' ),
        'JC Daily Progress'[Progress Date] = EARLIER ( 'TA-S-Curve'[Date Plan] )
            && 'JC Daily Progress'[SUBCON] = EARLIER ( 'TA-S-Curve'[Subcontractor] )
            && 'JC Daily Progress'[Asset] = EARLIER ( 'TA-S-Curve'[Asset] )
            && 'JC Daily Progress'[Projectname] = EARLIER ( 'TA-S-Curve'[ProjectName] )
    )
)

[AllanBerces]

Hi @danextian thank you very much, working perfectly. 

[AllanBerces]

Hi please refer below link.

TA_REPORT_TEST_ver.pbix

Thank you