Pull all-time minimum value ignoring some external filters

[Anonymous]

I have a requirement to pull all-time minimum sales for any given area . With the help of a community member, I was able to get the current year minimum sales. The catch is that the visual already has a Current year flag, so I'm not sure how to create a measure to remove the filter coming from the filter pane and pull the all-time minimum sales based on the Area selected from the slicer.

any help on this is greatly appreciated.

[Anonymous]

@Anonymous Then try this:

All_max=var tempTable=ADDCOLUMNS(SUMMARIZE(ALL('Dates'),'Dates'[Year],'Dates'[Month Name]),"_max",[Actual Sales])

return MAXX(temptable,[_max])

[Anonymous]

@Anonymous 

it didn't work . I was expecting jul 2020 value (i.e 4,030,542.55) to repeat agianst each month on the visual

[Anonymous]

It's weird because for me it works as intended...

[Anonymous]

@Anonymous Replace ALLSELECTED() with ALL('Dates').

[amitchandak]

@Anonymous , Try to add removefilters or all

calculate([Min value], all(Table[current year flag])

or

calculate([Min value], removefilters (Table[current year flag])

https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak

[Anonymous]

@amitchandak @Anonymous 

I changed from Min to Max as some months had no data.

I tired both but I am not getting what I wanted

all Time Max_1 = CALCULATE([Current Year Max Sales],all(Dates))

all Time Max_2 = CALCULATE([Current Year Max Sales],all(Dates[Current Year Flag])).

Current year max is fine but all time max was 4,030,542.55 but getting a different result

I have also included the pbix file below.

Sample Data