Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@cassidy , Put your current return statement into this one and try
maxx(summarize(Table,Table[division], Table[Offer],"_1",<Current return statement >),[_1])
@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":
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |