how to add 1 to a var

[Jeanxyz]

Hi,

I want to get the week number of next week based on filter context. Below is the measure I have written, for some reason, the var next_week always generates 1. However, var week seems to work correctly. Why add 1 to var week causes a problem?

weekly_cutoff =

var year=calculate(max(Dim_Calendar[Year]),keepfilters(dim_calendar[Year]))

var week=calculate(max( Dim_Calendar[WeekNumber]),keepfilters(Dim_Calendar[WeekNumber]))

var next_week = week + 1

//var cut_off=maxx(filter(Dim_Calendar,Dim_Calendar[Country]=[Selected_Country] && Dim_Calendar[Year]= benchmark_year && Dim_Calendar[WeekNumber]=[benchmark_week] && Dim_Calendar[Workday WTD]=1),Dim_Calendar[Date])

return

next_week

[mahoneypat · Accepted solution]

My guess is that your year and week variables are returning blank, and blank + 1 = 1.  Try returning those instead of next_week to see if they are working correctly.  Why not just use MAX(Dim_Calendar[WeekNumber])?  Why do you need the CALCULATE with KEEPFILTERS?

Pat

[Jeanxyz]

I would like to correct myself, actually the problem is not due to data refreshment, but because I have a country filter in the selection pane, because there is no data between week 1-23, the var week measure only generates result from week 23, while var next_week will generate 1 since var week=0. I should have paid attention to the filtering context.

[Jeanxyz]

There seems to be some data refreshment issue. Now var next_week generates correct results.

[Jeanxyz]

Here is the result of var week. As you can see, it works properly.  By the way, you are right that I don't need keepfilters() in this measure.