Show only the values of the last selected month

[Jul1an0]

Hello,

I want to show a time series in a graph and only the value of the last selected month in a table. The values of the time serie cannot be sum. I trying to use the folliwing measure:

pimLastValue = CALCULATE(_pim[pim_total],

                    DATESINPERIOD(dCalendar[date],

                                    MAXX(ALLSELECTED(dCalendar[date]),dCalendar[date]),

                                    1,

                                    MONTH))

But this measure returns only the most recent month, insted the last selected month. Can sobody help me?

[v-zhangti]

Hi, @Jul1an0 

Please try the following formula.

pimLastValue =
CALCULATE (
    _pim[pim_total],
    FILTER (
        ALLSELECTED ( dCalendar[date] ),
        dCalendar[date] = MAX ( dCalendar[date] )
    )
)

If this does not solve your problem, please provide example data.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.