Forum Discussion
LastNonBlank Measure not working
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:
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.
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 TeamIf 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
4 Replies
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
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 TeamIf 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
