ALL not behaving as expected

Question

Hi,&nbsp;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.ThxJan&nbsp;

spartabi · Accepted Answer

JuanSombrero&nbsp;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&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;

Forum Discussion

ALL not behaving as expected

2 Replies

Related content

line chart not behaving as expected

Expression.SyntaxError: Token ',' expected.

ALL function not behaving as expected

List.Generate, make behave like Accumulate or XL REDUCE

Fabric IA skill agent is not behaving as expected