Total SUM of Multiple Values With Filters

Hi Anonymous,

Please create a new table using the following formula, which combine the different columns to one columns.

NewTable =
UNION (
    SELECTCOLUMNS (
        Table,
        "QC Artist", Table[1 QC Artist],
        "Linear KM", Table[Linear KM],
        "QC time", Table[1QC Time(min)]
    ),
    SELECTCOLUMNS (
        Table,
        "QC Artist", Table[2 QC Artist],
        "Linear KM", Table[Linear KM],
        "QC time", Table[2QC Time(min)]
    ),
    SELECTCOLUMNS (
        Table,
        "QC Artist", Table[3 QC Artist],
        "Linear KM", Table[Linear KM],
        "QC time", Table[3QC Time(min)]
    )
)

Then create measure like the original post, and display it in table.

Total_Linear =
SUM ( NewTable[Linear KM] )

Total_Time =
SUM ( NewTable[QC Time (hr)] )

Best Regards,
Angelia