How can I calculate cumulative market share between Products month by month?

[sdrco]

Hi Everyone,
 
I have a problem. I can not calculate monthly cumulative market share. How can I calculate cumulative market share between Products, month by month or region by region or staff by staff or unit by unit?
 
Can you help me?
 
Table; goo.gl/gULjxL

[sdrco]

Hi all again,

Thanks for your answers. I will apply your solutions. But that links working ( http://goo.gl/gULjxL ) please cut and paste your browser or click again please.

Thanks.

Serdar.

[v-haibl-msft · Accepted solution]

@sdrco

Because your table cannot be accessed, I use some sample data as below.

We can create measures with following formulas.

Cumulative By Month_Product = 
CALCULATE (
    SUM ( Table1[Market Share] ),
    FILTER ( ALLSELECTED ( Table1 ), Table1[Date] <= MAX ( Table1[Date] ) ),
    VALUES ( Table1[Product] )
)

Cumulative By Month_Region = 
CALCULATE (
    SUM ( Table1[Market Share] ),
    FILTER ( ALLSELECTED ( Table1 ), Table1[Date] <= MAX ( Table1[Date] ) ),
    VALUES ( Table1[Region] )
)

Best Regards,

Herbert

[KGrice]

Hi @sdrco. The link to your table isn't working for me, so it's hard to give specific help. However, you might find this DAX pattern helpful in writing the DAX for doing cumulative totals. They provide the formulas and quite a few examples to get your started.