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 the table shows the data FOR THAT SPECIFIC CHOSEN MONTH.

How do I achieve that efficiently?

Thanks!

Michael

 

 

 

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

1 Reply

  • 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