Forum Discussion
Recreating a Table Visual Total via Measure
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] ) )
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] )
)
Hey johnt75 ,
this solution works if I include it in the table visual:
However, if I want to include it in a column chart, it does not work and shows up as blank
This is exactly the purpose for which I need the calculation. Is there a way to do it?
Thanks a lot and kind regards
Marcel
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 ?
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