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] )
)
johnt75's avatar
johnt75
Super User
3 years ago

The measures I wrote work for me

 

For some reason your measures are returning blank in the total row of the table, whereas mine returns the correct total. Are you applying any extra filters to the visuals ?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

johnt75 my bad! I had the measure included in Plan 2 Value as a variable. Having two separate measures as you intially proposed did the trick! Thanks a lot fpr the quick support and your insight!

 

Kind regards

Marcel