Default Measure with interactions

[Anonymous]

Hello friends,

I want my table to show the numbers of the LAST MONTH only by default (when user opens the report)

But I want my users to be able to click on any bar on the upper chart so that the table shows the data FOR THAT SPECIFIC CHOSEN MONTH.

How do I achieve that efficiently?

Thanks!

Michael

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may try to create a measure like below:

Measure =
VAR a =
    SUMMARIZE (
        'Table',
        'Table'[category],
        "b", CALCULATE (
            SUM ( 'Table'[Sales] ),
            FILTER (
                'Table',
                MONTH ( 'Table'[Date] ) = MONTH ( MAXX ( 'Table', 'Table'[Date] ) )
            )
        )
    )
RETURN
    SUMX ( a, [b] )

Regards,

Cherie