How to do it...

To complete this recipe, do the following:

  1. Create the following measure:
MC Sum = 
VAR __Column1 = SELECTCOLUMNS('R01_Table',"__Column",'R01_Table'[Value1])
VAR __Column2 = SELECTCOLUMNS('R01_Table',"__Column",'R01_Table'[Value2])
VAR __Column3 = SELECTCOLUMNS('R01_Table',"__Column",'R01_Table'[Value3])
VAR __Column4 = SELECTCOLUMNS('R01_Table',"__Column",'R01_Table'[Value4])
VAR __Table = UNION(__Column1,__Column2,__Column3,__Column4)
RETURN
SUMX(__Table,[__Column])
  1. On a Report page, create a Card visualization and place the MC Sum measure into the Fields area.