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.
Hi there,
Percentage Attainment % = DIVIDE([PAC2],[PWR],0) PAC2 = IF(HASONEVALUE(AssessData[Term]) && HASONEVALUE(AssessData[Subject]) , CALCULATE(COUNTA(AssessData[Assessment]), AssessData[Assessment]<>"" ), 0 ) PWR = IF(HASONEVALUE(AssessData[Term]) && HASONEVALUE(AssessData[Subject]) , CALCULATE( COUNTA(AssessData[Assessment]), ALL(AssessData[PerCentAttainName]), AssessData[Assessment]<>"" ), 0 )
Solved! Go to Solution.
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-us...
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-us...
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.
@Anonymous I ran into this issue and your post helped me fix my problem and for that I want to thank you!
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |