cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mshparber Established Member
Established Member

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!

MichaelCapture.JPG

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-cherch-msft
Microsoft

Re: Default Measure with interactions

Hi @mshparber

 

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Microsoft v-cherch-msft
Microsoft

Re: Default Measure with interactions

Hi @mshparber

 

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,458)