LastNonBlank Measure not working

[ArchStanton]

Hi,

I have tried to re-open a message that I previously accepted as a solution, it turns out the code doesn't work for all 3 Teams in the pbix file:

https://ufile.io/dkhq78t8

I have tried using this measure that correctly returns the last non blank value for Team A = 2, B, = 6- but C is 36?

The LastNonBlank Value for Team C is 12 not 36.

CALCULATE(

     LASTNONBLANKVALUE( Sheet1[KPI],Sum(Sheet1[KPI])),

     FILTER(

           Sheet1,Sheet1[Area] = "Team A"

     ) )

[ThxAlot]

[ArchStanton]

Thanks but that doesn't work, I need to apply a Filter on Area as I have many different Team names.

This is for a Card Visual

[Anonymous · Accepted solution]

Hi @ArchStanton ,

Please try:

Last Value = 
IF(ISBLANK(SELECTEDVALUE('Sheet1'[Area])),
"Please select an area",
CALCULATE(
    LASTNONBLANK(Sheet1[KPI], 1),
    ALLSELECTED('Sheet1'[Area])
)
)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[ArchStanton]

This works perfectly - many thanks for this!