Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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.

 

image.png

 

6 REPLIES 6
Anonymous
Not applicable

@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
Not applicable

@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

 

image.png

 

Anonymous
Not applicable

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

Anonymous
Not applicable

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

amitchandak
Super User
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

Anonymous
Not applicable

@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

 

image.png

I have also included the pbix file below.

Sample Data  

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors