Last Value <> from null and 0

[Fcoatis]

Hello everyone,

Need some help with a mesure that returns me the last value different from null and zero per category.

Here is the sample pbi with a simulated result table expected.

Thank you

[Emrah_Külünk]

Here is the sample file.

[Fcoatis]

Hello, @Emrah_Külünk 

Can you post the link of your solution? I tried your mesure in my model and didnt got the same result.

Thanks

[Emrah_Külünk · Accepted solution]

Hi,

You can create a measure like;

last value =

var max_date = CALCULATE(MAX('Table'[Dates]),'Table'[Value] <> 0 , ALLEXCEPT('Table','Table'[Category]))

var max_value = CALCULATE(SUM('Table'[Value]) , 'Table'[Dates] = max_date)

return max_value

[Fcoatis]

@Emrah_Külünk thank you. It worked!