How to calculate a mix% of my total sales based on selected filters

[Stephane5959]

Hi,

I am trying to get a column giving me the % of total sales per item. I am using a formula using =Divide([sum of sales],([sum of sales],all[list of items]). However if i filter the pivot for some specific item list, it keeps giving me the % of Total and not the filtered set.

Is there a way to have the formula work based on total filtered % ?

Thanks a lot

[Fowmy · Accepted solution]

@Stephane5959 

Replace your table names and field names.

Measure = 

Divide(
    [sum of sales],
    CALCULATE(
        [sum of sales],
        ALLSELECTED([list of items])
    )
)

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Stephane5959]

Thank you so much !