Forum Discussion

miriambb's avatar
miriambb
Icon for Helper I rankHelper I
3 years ago
Solved

Calculate measure with a filter

Hi everyone,    I am trying to create 9 box view. In particular I am looking at the calculaled field (headcount %) that changes depending on the filters applied. for instance, I have a total headco...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    miriambb Maybe:

    % HC = DIVIDE(CALCULATE(SUM(Euro1[Headcount])),
                CALCULATE(SUM(Euro1[Headcount]),ALLEXCEPT(Euro1,Euro1[Department]))) + 0 
miriambb's avatar
miriambb
Icon for Helper I rankHelper I
3 years ago

Greg_Deckler thank you and my apologies, 

 

this is our calculated field 

% HC = DIVIDE(CALCULATE(SUM(Euro1[Headcount])),
                CALCULATE(SUM(Euro1[Headcount]),ALL(Euro1))) + 0 
 
we would like any filters such as Department so the % is calculated it based on that headcount rather than from the total headcount as it is now.
 
Thank you
and please let me know if this helps
Miriam
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

miriambb Maybe:

% HC = DIVIDE(CALCULATE(SUM(Euro1[Headcount])),
                CALCULATE(SUM(Euro1[Headcount]),ALLEXCEPT(Euro1,Euro1[Department]))) + 0