Running Sum

[Anonymous]

Wanted to create a report like as below.What would be best DAX formula to calucate sum of sales and %.

Product	Sales	Sum of Sales	%
Category A	10	100	10%
Category B	20	100	20%
Category C	30	100	30%
Category D	40	100	40%

[Ashish_Mathur]

Hi,

Write these measures:

Sales = SUM(Data[Sale])

Sales of all products = CALCULATE([Sales],ALL(Data[Product]))

Sales share = [Sales]/[Sales of all products]

Hope this helps.

[Mariusz · Accepted solution]

HI @Anonymous 

Try something like.

Measure = 
DIVIDE(
    SUM( 'Table'[Sales] ),
    CALCULATE(
        SUM( 'Table'[Sales] ),
        ALL( 'Table' )
    )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

thanks ,this working. Small correction.There is a filter. 

Measure =
DIVIDE(
    SUM( 'Table'[Sales] ),
    CALCULATE(
        SUM( 'Table'[Sales] ),
        ALLSELECTED( 'Table' )
    )
)