topic Re: percent from total - remove slicers in DAX Commands and Tips

percent from total - remove slicers

sapirmarko — Tue, 31 Jan 2023 13:33:43 GMT

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 :

Re: percent from total - remove slicers

olgad — Tue, 31 Jan 2023 13:42:30 GMT

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

Re: percent from total - remove slicers

sapirmarko — Tue, 31 Jan 2023 14:00:01 GMT

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

Re: percent from total - remove slicers

olgad — Tue, 31 Jan 2023 14:48:51 GMT

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.

Re: percent from total - remove slicers

sapirmarko — Wed, 01 Feb 2023 12:08:42 GMT

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

Re: percent from total - remove slicers

olgad — Wed, 01 Feb 2023 14:05:30 GMT

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