How to ignore Drillthrough Filters?

[_fmigg]

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

[v-yuta-msft]

@_fmigg ,

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

Regards,

Jimmy Tao