Forum Discussion
Sort By Column changes the Measure results
I have found the solution (if you are interested!) - a blog article posted by Chris Webb (well done, Chris!) - https://blog.crossjoin.co.uk/2015/12/15/power-bi-desktop-sort-by-column-and-dax-calculations-that-use-the-all-function/
I removed the measure [PWR] and [Percentage Attainment %], replacing the latter with:
PA2 = DIVIDE([PAC2],
CALCULATE([PAC2],
ALL(AssessData[PerCentAttainName],AssessData[PerCentAttainID])
)
,0)The percentages now flow through irrespective of whether the Sort By Column function has been applied. Phew.
I have found the solution (if you are interested!) - a blog article posted by Chris Webb (well done, Chris!) - https://blog.crossjoin.co.uk/2015/12/15/power-bi-desktop-sort-by-column-and-dax-calculations-that-use-the-all-function/
I removed the measure [PWR] and [Percentage Attainment %], replacing the latter with:
PA2 = DIVIDE([PAC2],
CALCULATE([PAC2],
ALL(AssessData[PerCentAttainName],AssessData[PerCentAttainID])
)
,0)
The percentages now flow through irrespective of whether the Sort By Column function has been applied. Phew.
Anonymous I ran into this issue and your post helped me fix my problem and for that I want to thank you!
Woah, I had the same issue but with ALLSELECTED() instead of ALL().
Works in ALLSELECTED() too!
Thank you.I was looking for a solution for this, and I never imagined it could be such a small thing making my life difficult. 😅
Thanks for sharing.
