OFFSET - understanding behavior in the context filters

[Nese_FZ]

Good afternoon, Could anyone help me understand the behavior of this new offset function considering the filters applied to the measurements used?

The "SALDO INICIAL 2" column should bring the previous value of the "SALDO ACUM" column, but only a few lines are returning.

SALDO INICIAL 2 =

CALCULATE([SALDO ACUM],

OFFSET(1,ALLSELECTED(SaudeDigital[LINHA]),

ORDERBY(SaudeDigital[LINHA], DESC)))

SALDO ACUM =

VAR MaxIndice = Max(SaudeDigital[LINHA])

return

CALCULATE([Variação],

FILTER(ALL(SaudeDigital), SaudeDigital[LINHA] <= MaxIndice), SaudeDigital[NRUBRICA] = "UN. SAÚDE DIGITAL")

Considering that I already have an external filter applied on this page....

thanks a lot for the help

[Nese_FZ]

Thanks Brian, but it didn't work. It's not that context. From what I'm seeing, what's influencing the behavior is the SALDO ACUM measure, because if I insert removefilters the problem is solved. But then I can't apply external filters (month for example)

[BrianConnelly]

Provide sample data, Ill take a stab at it.  I have worked with it before and have had success.

[Nese_FZ]

Hi Brian, take a look if it´s good. Tks a lot

https://drive.google.com/file/d/1aYwt1L15pBTGRAKS_8fXxZzGuzhCjPDX/view?usp=share_link

[BrianConnelly]

Your problem is not in the Offset.  If you are able to dimensionalize the transaction table where LINHA is a dimension along with the Nrubrica and Descricao da conta is as well.  I don't know the data enough, but know that in the offset you are using an all selected becuase of duplicate records, but in the ACUM you have specific filter criteria.

[BrianConnelly]

Please read the article....Introducing window functions in DAX - SQLBI