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.
Woah, I had the same issue but with ALLSELECTED() instead of ALL().
Works in ALLSELECTED() too!
Thank you.