Sum of last month by default plus sum of selected months

[Irek]

Hi, 

I'm struggling with calculation that will show on card sum of values from last month by defeault or for selected months if they are selected. I don't have a problem with last month value and also everything works fine when I choose one month. but when I'm choosing two or more months I'm getting value just for last month in selection. for example if I choose Jan and Feb I will get value from Feb and I need to see Jan value plus Feb value. 

my calculation: 

calculation =

VAR maxDate=CALCULATE(MAX('table'[date]),ALLSELECTED(table'))

RETURN

IF(MAX('tabler'[date])=maxDate,

CALCULATE(

sum('table'[value]),

FILTER(

ALLSELECTED('All Worker'),

'table'[date]=maxDate

)

)

)

thank you

Marcin

[Irek]

Hi @lbendlin , 

Date	Sell
01.01.2023	10
01.02.2023	12
01.03.2023	10
01.05.2023	11

My last month in example data is May. Goal is to see in the card last month sell by defeault when user open dashboard, for these case 11, but when user will choose different month card should include that , March 10. 

it should also sum sale when user choose few months, for example February and March should give 22. 

I know how to show all sum of all sale by deafult and then filtered months or how to show latest but don't know how to join both calculation in one. 

Thank you

Marcin 

[lbendlin · Accepted solution]

you need to use ISFILTERED. See attached.

[Irek]

Thank you @lbendlin, 

Your calculation helped me a lot, but there was another isue, I had date filter (last 12 months) on whole page, that why even when I cleared the slicer card was showing "whole' sum of sales 🙂

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523