percentage of total on multiplied columns

[sp91]

Hello,

I want to show percentage of total (below). The columns I have are (at a row level) are price range, unit price, total units sold. I want to show percentage of total grouped at the price range level. How can I do this? Thx!!

[ribisht17]

@sp91 

Please close the thread if it helped you so that it can help others as well

Regards,

Ritesh

[ribisht17 · Accepted solution]

@sp91 

Basically something like this

PercOfProducts =

DIVIDE (

    [Total Sales],          

    CALCULATE (

        [Total Sales],      

        ALL ( Sales )         -- filtered by ALL Sales

)

Regards,

Ritesh