Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Recreating a Table Visual Total via Measure

Hello all,   in my organization's project management we compare different plan values and actual values of our projects. Projects that do not have one particular plan value are of particular intere...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    Create a measure like

    Plan Value by Project = SUMX( 'Project master', SUMX( RELATEDTABLE('Plan 1'), 'Plan 1'[Plan value]))

    which you can then use in a filter, like 

    Plan 2 value =
SUMX (
    FILTER ( 'Project master', [Plan value by project] = 0 ),
    SUMX ( RELATEDTABLE ( 'Plan 2' ), 'Plan 2'[Plan value 2] )
)
v-henryk-mstf's avatar
v-henryk-mstf
Community Support
3 years ago

Hi Anonymous ,

 

Whether the advice given by johnt75  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.


Looking forward to your feedback.


Best Regards,
Henry