Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculation with filter

I have a measure that I'm multipying by 2% on last year for sales managers.  I want to exclude 3 sale managers names from that  calculation.  My formula does not work.   test = CALCULATE(SUM([YAGO...
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    maybe you need just smth like

    Measure =
var _multiplier = IF(SELECTEDVALUE('RSM Performance'[Sales Manager]) = "Russell Curtis" || SELECTEDVALUE('RSM Performance'[Sales Manager]) = "Jarrod Patrick" || SELECTEDVALUE('RSM Performance'[Sales Manager]) = "Nigel Smith", 1, 1.02 )

RETURN
_multiplier * calculate(sum('RSM Performance'[YAGO Volume]))

    ?

     

az38's avatar
az38
Community Champion
6 years ago

Anonymous 

what column contains names?

show data example, please

Anonymous's avatar
Anonymous
Not applicable
6 years ago

for example: all YAGO volume is multiplied by 2% to get the AOP Target - what I am trying to do is have the 3 names (Russell Curtis and Jarrod Patrick and Nigel Smith) in the Sales Manager column be excluded from the AOP Target of 2% so having their targets showing no change to that in the TY Volume column