Need help in dax query to show next year value

[mdaamirkhan]

Hi 

Need help in dax query to show next year value below is thw screenshot.

I am trying to show two year value 

2021 --> value is showing correctly 5
2022--> its showing wrong value. it should show 2

Can you please provide the dax

[MFelix · Accepted solution]

Hi @mdaamirkhan ,

Without any data and data model is difficult to give the correct formula, but believe that the issue ios on your filtering.

Since you are doing a filter on a tabvle when you do a simple FILTER(TABLE)) this will return the current context in this case you will be looking at current year only. You need to do a FILTER(ALL(Table)).

So you measure should look similar to this:

Estimated this year + 1 =
var thisyear = Year(now()) + 1
var NSM = DISTINCTCOUNT(Input_Contract_Report[months])
var val =
CALCULATE(NSM
,
FILTER( ALL(Input_Contract_Report), Input_Contract_Report[End Date].[Year] = thisyear

)
Return
val