Cummulative sales from most sold to least sold product for a selected period

[alexrf86]

Hi! I am trying to cummulate my sales from the most sold to the least sold product for a selected period having a data Table with this structure: --> Date, Product, Sales

If the table did not contain Date, this measure would work properly:

Cummulative_sales = CALCULATE(sum(table[sales]), FILTER(all(table),table[sales]>=MAX(table[sales])))

However I need to build up a table with product and cummulative sales (from the most sold product to the least sold product) filtering by a period date, so I tried:

Cummulative_sales = CALCULATE(sum(table[sales]), FILTER(

ALLEXCEPT(table, table[date]), table[sales]>=MAX(table[sales])))

But table is not cummulating data 😥

[v-jayw-msft]

Hi @alexrf86 ,

Can you show some sample data and expected result to us?

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[alexrf86]

Hi @v-jayw-msft ! Thanks for your answer.

My database contains a table with the following data:

Date	Prod	Sales
01/01/2020	k2	3
01/01/2020	a1	4
01/01/2020	b5	10
02/01/2020	k2	1
02/01/2020	a1	2
02/01/2020	b5	3
03/01/2020	k2	2
03/01/2020	a1	3
03/01/2020	b5	4

I want to build up a table with Product and cummulative Sales from most sold product to least sold product and using date as a filter. For instance, selecting a date filter period from 01/01/2020 to 02/01/2020 my product sales would be:

k2	4
b5	13
a1	6

So the desire result is:

b5	13
a1	19
k2	23

I used to cummulate sales without date dimension, so this measure used to work:

Cummulative_venta_neta = CALCULATE(SUM(table[sales]),

                                                                  FILTER(ALL(table),table[sales]>=MAX(table[sales]))).

However when I entered the date dimension in Table Data, measure is not cummulating and date filter is not working either.

May you please help me?

Thanks