Filtering by Column Using Matrix Visual

[Anonymous]

Is there a way of filtering by the column higlighted in red rather than the grand total of all of the rows combined. The below is a matrix visual.

Thank you in advance

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

You can add a measure similar to below into visual level filter to filter above Matrix.

Measure =
CALCULATE (
    SUM ( DATA[Value] ),
    FILTER ( DATA, DATA[Date] = CALCULATE ( MAX ( DATA[Date] ), ALL ( DATA ) ) )
)

Best regards,

Yuliana Gu