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've made a running total measure (Balance) to my table Transactions like this:
Solved! Go to Solution.
Hi @jmkvalsund ,
Can you provide dummy data and expected results?
In the dummy data I created myself, Balance and AccountValue have the same results.
Are you trying to calculate the cumulative value?
If so, you can try to remove the fields in the ALL function and modify them as follows.
Balance = Calculate(SUM(Transactions[AccountValue]),FILTER(ALL(Transactions),Transactions[TransactionsDTM]<=MAX(Transactions[TransactionsDTM])))
Balance MAX = MAXX(ALL(Transactions),[Balance])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jmkvalsund ,
Can you provide dummy data and expected results?
In the dummy data I created myself, Balance and AccountValue have the same results.
Are you trying to calculate the cumulative value?
If so, you can try to remove the fields in the ALL function and modify them as follows.
Balance = Calculate(SUM(Transactions[AccountValue]),FILTER(ALL(Transactions),Transactions[TransactionsDTM]<=MAX(Transactions[TransactionsDTM])))
Balance MAX = MAXX(ALL(Transactions),[Balance])
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a lot, this works!
Hi,
Try changing your RT measure like this:
Calculate(SUM(Transactions[AccountValue]),ALL(Transactions[TransactionsDTM]),Transactions[TransactionsDTM]<=MAX(Transactions[TransactionsDTM])))
Explanation:
RT calculation works also with the filter, but the interaction with external filters is a bit different:
Now when we introducte a filter this happens:
I suspect this might be the reason your MAXX is not working properly.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Hi, I tried your suggestion, but the result is still the same.
But then I narrowed down my datasource to contain just a few records, and now I see whats wrong:
The Max- and Min-values are not taken from the RT measure [Balance], but from the values in the column Transactions[AccountValue]...
Why??
The formula doesn't include this column at all, but the RT measure is based upon it. How does MAXX return values from the measure's datasource instead of the measure's values??
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |