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]))

    ?

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I've tried that but when I add the measure to my report, I get gray box with details

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

Are you sure you want to compare 'RSM Performance'[RSMP YAGO Volume] column with names? how is your data look like?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I don't want to compare 'RSM Performance'[RSMP YAGO Volume] column with names, but just exclude the 3 names from the volume calculation in the report  (ie. for those 3 names, the caculation wont have an effect)

    • az38's avatar
      az38
      Icon for Community Champion rankCommunity 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