Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hello,
To solve your issue you can change your formula for LatestRun to:
LatestRun = CALCULATE(MAX(Table1[RunID]),ALL(Table1))
Regards,
ElenaN
Hello,
To solve your issue you can change your formula for LatestRun to:
LatestRun = CALCULATE(MAX(Table1[RunID]),ALL(Table1))
Regards,
ElenaN
This seems to work!
However, what is the reason the initial LatesRunId measure didn't return the required outcome?
Thank you very much!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |