Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Percentilex Quartile measure help

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:

Screenshot 2020-10-01 153121.png


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:


Screenshot 2020-10-01 153728.png


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


Screenshot 2020-10-01 153806.png


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

Super User IX
Super User IX

Re: Percentilex Quartile measure help

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

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helper III
Helper III

Re: Percentilex Quartile measure help

@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":


Screenshot 2020-10-02 085349.png

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

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

Top Solution Authors
Top Kudoed Authors