Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I would appreciate the help of the community very much.
I am searching for a solution to summarize the values of column Count, but the result in SUM should summarize only the values from the current row backwards. For illustration, please note the line with index number 6.
Thank you very much for taking time and a good day.
Solved! Go to Solution.
Thank you for your quick feedback and your help.
I could implement your solution, but I have got this result.
I have added the code like this:
Did I something wrong?
Thank you for your patience.
@Anonymous strange..
Can you share your file?
Now it works. I have checked the Variable _curr_index and it was always empty. For this reason I have removed the function SELECTEDVALUE.
This are the results:
Here is the code:
Thank you a lot for your help.
@Anonymous
SUM RT =
VAR _curr_index =
SELECTEDVALUE ( Table[Index] )
RETURN
CALCULATE(
SUM(Table[Count],
REMOVEFILTERS(Table),
Table[Index] < = _curr_index
)
Thank you for your quick feedback and your help.
I could implement your solution, but I have got this result.
I have added the code like this:
Did I something wrong?
Thank you for your patience.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
130 | |
80 | |
53 | |
38 | |
35 |
User | Count |
---|---|
204 | |
81 | |
71 | |
53 | |
50 |