Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
  • some_bih's avatar
    some_bih
    3 years ago

    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

some_bih's avatar
some_bih
Community Champion
3 years ago

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