Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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/
User | Count |
---|---|
58 | |
21 | |
18 | |
16 | |
13 |
User | Count |
---|---|
85 | |
54 | |
45 | |
39 | |
21 |