Cumulative %

[GoodMan85]

Hello everybody,
I have a problem to create a measure in DAX for the cumulative percentage. I should make a column with the cumulative of the Percent N_ITEMS field already calculated. I attach the file. Thank you all.

 

[amitchandak]

@GoodMan85 , Try a measure like

calculate(sumx(values(Table[Item Code]) , [% N_ITEMS ]), filter(Table, Table[Item Code] <= max(Table[Item Code])))

[GoodMan85]

Hi Amitchandak

This mesure ins't work. I've a column = 100% for all row.

This the situation

 

[amitchandak]

@GoodMan85 , Try like

alculate(sumx(values(Table[Item Code]) , [% N_ITEMS ]), filter(allselected(Table), Table[Item Code] <= max(Table[Item Code])))

[GoodMan85]

@amitchandak 

Hi, nothing. I send you a private message.