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.
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.