Forum Discussion
Help please
Hello, I need help charting cummulative amount by open year. The matrix on the left side is displaying correct cummulative totals, using "Cur Bal running total in Co Year 2" measure, increasing left to right. But the matrix on the right side is not displaying correct percentages, using measure 3. The line chart looks good but is displaying the cummulative amounts, and not the percentages I need.
Hi Anonymous the best practice for ALLSELECTED function in DAX is just use it for visual. Do not use in measure that contain ALLSELECTED. In your example "Cur Bal running total in Co Year 2" measure contains ALLSELECTED and in Measure 3 you call it ("Cur Bal running total in Co Year 2" measure).
Reference: https://www.sqlbi.com/articles/introducing-allselected-in-dax/
You should rework you measure/s.
I hope this help
1 Reply
Hi Anonymous the best practice for ALLSELECTED function in DAX is just use it for visual. Do not use in measure that contain ALLSELECTED. In your example "Cur Bal running total in Co Year 2" measure contains ALLSELECTED and in Measure 3 you call it ("Cur Bal running total in Co Year 2" measure).
Reference: https://www.sqlbi.com/articles/introducing-allselected-in-dax/
You should rework you measure/s.
I hope this help