Forum Discussion
Pull all-time minimum value ignoring some external filters
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.
6 Replies
- amitchandak
Super User
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
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.
