cumulatives percentages

[liliachante]

Hello, I have an excel file with two columns Items and Number, I created a measure to have the item by  category  as a percentage based on the purchase of each customer. I would like to add an additional column to calculate cumulatives of the percentage  but I

don't know how to proceed, I want to use Dax formula But I only find formula, where a column is a Number , while my data are string 

Thank you in advance for your help.

best Regards, 

[Anonymous]

hey @liliachante 

use this measure.

% column = DIVIDE('Table'[Number],SUM('Table'[Number]))

Number cumulative = CALCULATE(SUM('Table'[Number]),FILTER(ALLSELECTED('Table'), 'Table'[Item]<= EARLIEST('Table'[Item])))

% cumulative = 
var sales=CALCULATE(SUM('Table'[Number]),FILTER(ALLSELECTED('Table'[Item]),ISONORAFTER('Table'[Item],MAX('Table'[Item]),DESC)))
var totalsales=CALCULATE(SUM('Table'[Number]),ALLSELECTED('Table'))
return DIVIDE(sales,totalsales)

regards,

Naveen

[liliachante]

Thank you for you help, but I have a question, Power bI count the blank , as I have some empty line , how can I do to remove the blank?, I think create another table with the two colum and remove customer without items, do you think it's a good idea? I really apreciate you help.

best regards

Lilia