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 am trying to Summarize a Table and calculate running total in a new Table
As you can see in the attached pictures, the TempTable (1st Picture) with its DAX codes
and when I try to SUMX the Column "Summary" from TempTabel to my result table its not workig at row level, I want to add up only if the values in [Order] is less than or equal to the row value in my result table [PnL_Order], somthing similar to a running total.
Any help is appreciated.
Solved! Go to Solution.
Please try it with this change
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
not the best but maybe quickest solution
var result =
summarize(pnl, [Pnl_Order], "Amount1",
var _curOrder = MAX ([Pnl_Order])
RETURN
CALCULATE(SUMX(temptable, [Summary]), temptable[Order] <= _curOrder )
I cannot use "temptable[Order]" its coming from VAR above, so instead I tried to use it inside a FILTER and the result is same:
Please try it with this change
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Do you have any thoughts about why the same concept would not give me a result in all rows, when I use it in a Measure instead of a Table
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |