Calculate with filter doesn't return expected value

[Anonymous]

Hi all,

I have a simplified example of what happen in practice.

There is a fact table in which history is kept. These can be identified with the RunID's.

I want to sum all the values from the lastest RunID (=2). This should be 100+200=300

In order to determine the latest RunID, I've created the following measure. I've created a card to verify and it states 2, as expected.

When I create my measure to sum all values from RunID 2 and reference to the previous measure, it just sums all values with a total of 330. If I 'hardcode' the lates RunID, it does return the sum of the values of only Run 2.

How come these measures don't return the same results?

[ElenaN · Accepted solution]

Hello,

To solve your issue you can change your formula for LatestRun to:

LatestRun = CALCULATE(MAX(Table1[RunID]),ALL(Table1))

Regards,

ElenaN

[Anonymous]

 This seems to work!

However, what is the reason the initial LatesRunId measure didn't return the required outcome?

Thank you very much!