ALL not behaving as expected

[JuanSombrero]

Hi,

I am trying to write a very simple 'ALL' statement, but it is not performing as expected, and I am trying to wrap my head around the 'why'...

So here we go...

Any clue why the Test_AllOutstandings is not ignoring the filter context from to rows, while that is clearly stated in my all statement (as seen in the formula bar)? I feel like I'm overlooking something very stupid here...

Any input would be greatly appreciated.

Thx

Jan

[SpartaBI · Accepted solution]

@JuanSombrero are you sorting that column by another column? If yes then you need to also add that column inside the ALL function.

Showcase Report – Contoso By SpartaBI

      

[JuanSombrero]

I am indeed! And I was absolutely unaware of that. Many many thx!