Get last value (last date) when using filter

[hama21]

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
nov/22
dec/22

I want to show the last value, according a filter visual I have in my report. For example, if I filter between january/22 and june/22 I want to return the value as 4 (last date = june/22, according my selection in filter). The problem is, when I'm using this measure calculate(sum(value), date = max(date), it's all returning the value for my last date (december/22) and not respecting the date range filter. Please, could you guys help me how to do this dax measure? 


Thank you!

[amitchandak · Accepted solution]

@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())

[hama21]

Thank you @amitchandak Works perfectly! Could you please explain the differece between the measure I was trying and your measures?

Thank you!

[VahidDM]

@amitchandak 

  All good mate, you are a hero in the PBI Community.  

😉

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[VahidDM]

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