CALCULATE with running filter

[Pikachu-Power]

hi all,

I have a measure like

CALCULATE ( Measure, Table2[Category] = "A" )

+ CALCULATE ( Measure, Table2[Category] = "B" )

+ CALCULATE ( Measure, Table2[Category] = "C" )

+ CALCULATE ( Measure, Table2[Category] = "D" )

+ CALCULATE ( Measure, Table2[Category] = "E" )

and so on...

Can I write it more compact? With a kind of running Filter?

Thanks for ideas.

[Pikachu-Power]

Thank you it worked 👍

The measure dont react to a slicer with A, B and C. Is it also possible to write it in such way that I can also filter it to A, B and C?

[johnt75 · Accepted solution]

Yes, you could do it like

Combined measure =
VAR summaryTable =
    ADDCOLUMNS (
        CALCULATETABLE (
            VALUES ( 'Table2'[Category] ),
            KEEPFILTERS('Table2'[Category] IN { "A", "B", "C" })
        ),
        "@val", [Base Measure]
    )
RETURN
    SUMX ( summaryTable, [@val] )

[johnt75]

You could do something like 

Combined measure =
VAR summaryTable =
    ADDCOLUMNS (
        CALCULATETABLE (
            VALUES ( 'Table2'[Category] ),
            'Table2'[Category] IN { "A", "B", "C" }
        ),
        "@val", [Base Measure]
    )
RETURN
    SUMX ( summaryTable, [@val] )