Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Default Measure with interactions

  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 th...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

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