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

Ignore Filter from Generated Table

So I used @Greg_Deckler 's quartile function from here:

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/QUARTILE/m-p/1064307

 

to create this measure in my report:

 

 

QUARTILE Orig = 
    VAR __Values = SELECTCOLUMNS('Quartile Table',"Values",[Revenue])
    VAR __Quart = MAX('Quartiles'[Quart])
    VAR __Median = MEDIANX(__Values,[Values])
    VAR __Count = COUNTROWS(__Values)
    VAR __Quartile =
        SWITCH(__Quart,
            0,MINX(__Values,[Values]),
            2,__Median,
            4,MAXX(__Values,[Values]),
            1,
                VAR __Median = IF(
                                    ISEVEN(__Count),
                                    MEDIANX(FILTER(__Values,[Values] < __Median),[Values]),
                                    MEDIANX(FILTER(__Values,[Values] <= __Median),[Values])
                                )
                RETURN __Median,
            3,
                VAR __Median = IF(
                                    ISEVEN(__Count),
                                    MEDIANX(FILTER(__Values,[Values] > __Median),[Values]),
                                    MEDIANX(FILTER(__Values,[Values] >= __Median),[Values])
                                )
                RETURN __Median
        )
RETURN
    __Quartile

 

 

I have a filter on the current page for another column in the Quartile Table called Supplier. When I filter for a particular supplier, the amounts for the above measure all simply return the same amount related to the supplier I selected which makes sense. I want to alter this measure so that when I filter for a supplier, it igornes the filter and returns the result for all suppliers instead. 

 

I tried putting ALL('Quartile Table'[Supplier]) pretty much everywhere possible, but that didn't really give me the right result either. 

1 REPLY 1
lbendlin
Super User
Super User

This should be sufficient

 

VAR __Values = SELECTCOLUMNS(ALL('Quartile Table'),"Values",[Revenue])

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