topic Re: Dynamic Cumulative or Total Ranning in DAX Commands and Tips

Dynamic Cumulative or Total Ranning

Talal141218 — Thu, 28 Sep 2023 06:55:40 GMT

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[ItemNo] <=max(Dim_Item[ItemNo]))). In Addition when i sort the items rely on the amounts the Formula will not works anymore , please look at the Pics:

Before

After sorting depend on Quantity :

Note : Earlier measure dos't work with my Power BI

Thanks in Advance 🙂

Re: Dynamic Cumulative or Total Ranning

Talal141218 — Thu, 28 Sep 2023 06:56:49 GMT

Is there any Expert can help me in this issue 🙂 ?

Re: Dynamic Cumulative or Total Ranning

Anonymous — Fri, 29 Sep 2023 02:48:04 GMT

Hi Talal141218 ,

It's normal, there's nothing wrong with it.

For your measure calculation logic, it does a cumulative sum based on your "Item Number" field, when you sort the "Quantity" field in the table visual, it doesn't change the logic of the calculation.

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.

Re: Dynamic Cumulative or Total Ranning

Talal141218 — Fri, 29 Sep 2023 09:14:20 GMT

Thanks for your answer. could you please share with me the formula, which I can sort the cumulative amount.

Re: Dynamic Cumulative or Total Ranning

Anonymous — Fri, 06 Oct 2023 03:07:03 GMT

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.