Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
2 years ago
Solved

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:   https://ufile.io/dkhq78t8   I have tried us...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

ThxAlot's avatar
ThxAlot
Super User
2 years ago

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        ArchStanton
        Power Participant
        2 years ago

        This works perfectly - many thanks for this!