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.
I have a table with set of integer IDs and another column called improvement which is a decimal column. I am trying to create a table visual which shows ID, Improvement and the Cumulative Improvement which is the total of previous and current improvement values. To make it clear I have an image below.
Cumulative Improvement is the column I want to show in my table visual. As you can see in the image it is the sum of the improvement of the current record and the cumalative improvement of the previous record.
I created a measure to achive this.
But what I get is the same value as Improvement column. What am I doing wrong here?
Solved! Go to Solution.
Very close. First thing, you need to do this as a column rather than a measure. Then you can use this code:
Cumulative Improvement = CALCULATE( SUM(Sheet1[Improvement]), all(Sheet1), Sheet1[ID] <= EARLIER(Sheet1[ID]) )
It seems your formula is correct. I can use this DAX expression to get expected result.
In your scenario, could you please share your PBIX file, so that we can make further analysis.
Regards,
Charlie Liao
Very close. First thing, you need to do this as a column rather than a measure. Then you can use this code:
Cumulative Improvement = CALCULATE( SUM(Sheet1[Improvement]), all(Sheet1), Sheet1[ID] <= EARLIER(Sheet1[ID]) )
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |