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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!