Percentage of Total based on Dynamic Filters (Sum = 100%)

[SimonGrams]

Hello everybody,

I try to rebuild the quick calculation "Percentage of total" in a new measure.

Measure = 

VAR Volume =
   '2_komplett'[Sessions]
VAR AllVolume =
   CALCULATE('2_komplett'[Sessions];ALL('2_komplett'))

RETURN
    DIVIDE ( Volume; AllVolume )

As long as I do not use any filters the result is just the way I want it to be (below both percentages next to each other, '%SG: Sessions' is the result of the quick calulation):

But as I use a filter (eg country, device) my measure still adjusts to the grand total. I want my measure to adjust to the filter (filtered value is new total ---> Sum is 100 %) - just as the quick calculation.

Does anyone know the solution to my problem?

Thanks in advance

[tringuyenminh92 · Accepted solution]

Hi @SimonGrams,

You could try ALLEXCEPT(table,columnyouwanttofilter) instead of ALL method. Hope it works

[SimonGrams]

Hi @tringuyenminh92,

works perfect, thanks a lot!!

I use 2 filters in my report: Country & Device

Measure = 

VAR Volume =
   '2_komplett'[Sessions]
VAR AllVolume =
   CALCULATE('2_komplett'[Sessions];ALLEXCEPT('2_komplett';'2_komplett'[Country];'2_komplett'[Device]))

RETURN
    DIVIDE ( Volume; AllVolume )