To complete this recipe, do the following:
- 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])
- On a Report page, create a Card visualization and place the MC Sum measure into the Fields area.