Cumulative Totals with filter

[Anonymous]

Hello,

I have a table with product sales data with a month column.

I created a measure to represent the percentage of the total. Now I need to make another column accumulating the percentage of the total (column PercentTotal). Remembering that I have the filter per month (single filtering), and the products are repeated in one month and others.

Follows PBIX file https://1drv.ms/u/s!Avwq0_QZmBwmgtUnB6iDHQ1f6KPM3A?e=P7ycSS 

Could anyone help with this?

With kind regards.

[AlB]

Hi @Anonymous 

PercentTotal V2 = 
VAR currentProduct_ = SELECTEDVALUE ( Sheet1[Product], MAX ( Sheet1[Product] ) )
RETURN
    DIVIDE (
        CALCULATE ( SUM ( Sheet1[Total] ), Sheet1[Product] <= currentProduct_ ),
        CALCULATE ( SUM ( Sheet1[Total] ), ALLSELECTED ( Sheet1 ) )
    )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

@amitchandak, thanks for the answer.

I would like to have these accumulated values sorted by the total. It stayed this way.

In my question I was not entirely clear about this earlier..

Regards.

[amitchandak · Accepted solution]

@Anonymous , Try like

divide( calculate(sum(sheet1[total]), filter(allselected(sheet1), sheet1[total] <= max(sheet1[total]))), calculate(sum(sheet1[total]), allselected(sheet1)))

[Anonymous]

@amitchandak, It worked by changing the signal to greater.

sheet1[total] >= MAX(sheet1[total])

@AlB Thanks for the answer.

[amitchandak]

@Anonymous , Try a measure like

divide( calculate(sum(sheet1[total]), filter(allselected(sheet1), sheet1[product] <= max(sheet1[product]))), calculate(sum(sheet1[total]), allselected(sheet1)))