To show a line in a graphic up to the selected week

[bayarri81]

I'm using this mesure:

Vtas Acum Sem Nova =

var Setmana_actual = WEEKNUM(TODAY())

return

CALCULATE (

[Vtas],

FILTER ( ALL( Calendario),

Calendario[Núm.Semana] <= MAX(Calendario[Núm.Semana])

&&

'Calendario'[Año Sem] = MAX(Calendario[Año Sem])

))

The question is that I don't want to show all the dark blue line.

Thanks in advance.

[FreemanZ · Accepted solution]

hi @bayarri81 

try like:

Vtas Acum Sem Nova =

var Setmana_actual = WEEKNUM(TODAY())

return

IF(

MAX(Calendario[WeekNumber])<=Setmana_actual,

CALCULATE (

[Vtas],

FILTER ( ALL( Calendario),

Calendario[Núm.Semana] <= MAX(Calendario[Núm.Semana])

&&

'Calendario'[Año Sem] = MAX(Calendario[Año Sem])

))

)

[bayarri81]

Thank you so much for your help!