Percentilex Quartile measure help

[cassidy]

I created a Measure using Summarize to create a table of Products & a Measure, then using that new column to create Percentile groups.  Lastly, an IF statement to try and mark the Percentile groups (Quartiles).

Looks like this:

The Product Detail table has a relationship with a Product Hierarchy table, however that relationship doesn't seem to be retained with how I wrote the Measure above.

Here it is with a Hierarchy (Division) and a Product (Offer), works great:

But if I pull it out, I'd expect the Quartiles to adjust to the Division, instead it repeats Q1:

This is a very large dataset in heavy use with hundreds of Measures, so I feel good about the relationships and I'd think my new Quartile Measure is the issue.

Any ideas?  Thanks

[amitchandak]

@cassidy , Put your current return statement into this one and try

maxx(summarize(Table,Table[division], Table[Offer],"_1",<Current return statement >),[_1])

[cassidy]

@amitchandak thank you for the reply.

Sorry if I wasn't clear, but the "Division" and the "Offer" are from two different tables and there are more levels to the Hierarchy than just Division.

Here is the relationship, joined by "CategoryCodeChain":