percent from total - remove slicers

[sapirmarko]

hi!

I want to build a DAX measure that calculate % of the total quantity

in this report, I have slicers of date, territory, and product category(will be single select).

every time I pick one category  I want to get the percent from total:

for example, if I pick CSD I want to get 85% -  2.2M / 2.6 M

important thing- I want that the date slicer will affect the measure, but if I pick another territory I want that the answer won't change. 

model looks like :

[olgad]

It changes because the nominator changes too.
that shall be your nominator

Calculate(Sales[Sales], ALL(Wholesalers[territory_name]))

Not sure what you want to achieve, but if you dont want the slicer to affect that visual at all you can simply set edit interactions to none. 

[sapirmarko]

I need to get the total sales that only the date slicer will affect about this measure, I can't dit interactions to none because it's part od another measure that need use with the other slicers

[olgad]

Fine, have you tried to change the nominator as suggested?

[olgad]

%=DIVIDE([Quantity Principal],  Calculate([Quantity Principal], All(WHS[TerritoryName])))
You need All to remove the filter from Territory

[sapirmarko]

If we break it down into factors, then I calculate the denominator in the following way:

CALCULATE(

[Quantity - Principal],

KEEPFILTERS(Sale_Out[paid_date]),

ALL(Product1[category_name]),

ALL(Wholesalers[territory_name]))

when I filter the category_name the answer doesn't change -  that good

when I filter the paid_datethe answer change -  that good

but when I filter the territory_namethe answer change -  that not good