Forum Discussion
Cumulative %
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.
4 Replies
GoodMan85 , Try a measure like
calculate(sumx(values(Table[Item Code]) , [% N_ITEMS ]), filter(Table, Table[Item Code] <= max(Table[Item Code])))
Hi Amitchandak
This mesure ins't work. I've a column = 100% for all row.
This the situation
GoodMan85 , Try like
alculate(sumx(values(Table[Item Code]) , [% N_ITEMS ]), filter(allselected(Table), Table[Item Code] <= max(Table[Item Code])))
