Forum Discussion
Talal141218
2 years agoHelper III
Dynamic Cumulative or Total Ranning
Hi Profis, I have question regarding to cumulative measure. I create i cumulative measure as below : RT = CALCULATE([CM_Stock_Amount_ExclRes_piec], FILTER(ALLSELECTED(Dim_Item[ItemNo]), Dim_Item...
- Anonymous2 years ago
Hi Talal141218 ,
Please try below steps:
1. below is my test table
Table:
2. create a measure with below dax formula
cumulative = VAR cur_quantity = SELECTEDVALUE ( 'Table'[Quantity] ) VAR tmp = FILTER ( ALL ( 'Table' ), [Quantity] >= cur_quantity ) RETURN SUMX ( tmp, [Quantity] )3. add a table visual with table fields and mesure
Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Talal141218
2 years agoHelper III
Is there any Expert can help me in this issue 🙂 ?