Forum Discussion

efjw's avatar
efjw
Icon for Helper I rankHelper I
2 years ago
Solved

Displaying latest value on gauge visual (via DirectQuery)

Hi! I am trying to display the latest value of actualtotalbuildingwaterflow on my gauge visual. I created a new measure currentTBWF to get the latest value of actualtotalbuildingwaterflow but it retu...
  • efjw's avatar
    efjw
    2 years ago

    bhanu_gautam Unfortunately that still returned as blank for me but I tried 

    currentTBWF = MAX('demotagdata11'[actualtotalbuildingwaterflow]) and it works now! Thanks for your help 🙂
bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

efjw , Try updaing measure as

 

currentTBWF =
CALCULATE(
LASTNONBLANK('changi demotagdata11'[actualtotalbuildingwaterflow], 'changi demotagdata11'[datetime]),
FILTER(
ALL('changi demotagdata11'),
'changi demotagdata11'[datetime] = LASTDATE('changi demotagdata11'[datetime])
)
)