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 Read multiple posts and tried multiple variants to write this formula but it isn't working as expected.
Simply put, I want "Measure 3" to be running total of Measure Tax Due.
This is the code I'm using for Measure 3:
but got exactly the same result:
@Anonymous
Any help would be highly appreciated!
Hi, @Anonymous ;
This is supposed to be matrix, right? I'm a little confused about your data,like below:
If use table ,it will show right.
So can you share more information about your data or share .PBIX to remove sensitive information?
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , you should prefer separate year/date table
Measure 3 =
calculate([Tax Due], filter(allselected(year), years[year]<=max(years[year])))
or
Measure 3 =
calculate([Tax Due], filter(allselected(year), years[Date]<=max(years[Date])))
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |