cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
_fmigg
Regular Visitor

How to ignore Drillthrough Filters?

Hi, 

 

I have a table of food products from a pet store. I'd like to analyze by brand each food product. The hierachy goes like this.

ANIMAL -> SEGMENT PRICE -> BRAND -> PRODUCT

 

What I've done is that in one page create a drillthrough to a page with specific BRAND details using [BRAND] column as drillthrough.  The customer asked if it could be possible at the Brand details page to have a table with top 10 of the most sold PRODUCTS of by the ANIMAL.

 

So if I Drillthrough a brand called "Happy Doggie" in which ANIMAL = Dog, the table should display the top 10 sold PRODUCTS where ANIMAL = Dog ignoring the BRAND.

 

I'm just wondering if there is a way to achieve this, since I tried using DAX by applying some FILTER, ALLEXCEPT, and ALL combinations but it seems not to work. Also tried with RANKX and Top N filtering with no successful results.

 

Is that possible?

Thanks

_fmigg

1 REPLY 1
v-yuta-msft
Community Support
Community Support

@_fmigg ,

 

Not very clear about your requirement, please share some sample data(Do not input sensitive data) and your expected results.

 

Regards,

Jimmy Tao

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!