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.
Messrs Ferrari and Russo (The Definitive Guide to DAX, p. 348) published a brilliant measure [PercOnParent] for calculating percentages on hierarchies. My problem has been that it doesn't work if I sort my row labels on another column. For anyone familiar with their measure, why does this happen and how can I fix it?
Solved! Go to Solution.
I'm not familiar with the measure you talk about, but I know how to write % of parent. I can tell you that if you sort your columns, you need to include both the column name and sort column in any ALL function. So this
CALCULATE(SUM(table[value]),ALL([category]))
becomes this.
CALCULATE(SUM(table[value]),ALL(prod[category],prod[category sort]))
i cover this towards the bottom of this article. https://exceleratorbi.com.au/the-all-function-in-dax/
Also brilliant--thank you, Matt!
PS: I'm enjoying the new 3rd ed. of Supercharged!
I'm glad you like it. I always appreciate a review at Amazon if you are willing. This is one of the best ways that other people can find my book (which is good for me, and them, I think 🙂 )
I'm not familiar with the measure you talk about, but I know how to write % of parent. I can tell you that if you sort your columns, you need to include both the column name and sort column in any ALL function. So this
CALCULATE(SUM(table[value]),ALL([category]))
becomes this.
CALCULATE(SUM(table[value]),ALL(prod[category],prod[category sort]))
i cover this towards the bottom of this article. https://exceleratorbi.com.au/the-all-function-in-dax/
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 |
---|---|
46 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
51 | |
47 | |
16 | |
13 |