Forum Discussion

hama21's avatar
hama21
Helper I
3 years ago
Solved

Get last value (last date) when using filter

Hi, I'm have one database that's look like this: date value jan/22 4 feb/22 5 mar/22 6 abr/22 7 may/22 4 jun/22 5 jul/22 4 aug/22 6 sep/22   oct/22   n...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    hama21 , I Just Noticed VahidDM , Already replied. Check that first.

     

    Try like

     

    calculate(lastnonblankvalue(Table[Date], Sum(Table[Value])) )

     

    or

     

    calculate(lastnonblankvalue(Table[Date], Sum(Table[Value])), allselected())

VahidDM's avatar
VahidDM
Super User
3 years ago

HI hama21 

 

Do you use the Slicer visual to set a filter on your report?

Do you use that measure in a card? Have you checked the Slicer (filter) interactions?

 

Read this:

Change how visuals interact in a Power BI report

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube