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 Combined Volume])*1.02, 'RSM Performance'[RSMP YAGO Volume]<>"Russell Curtis", 'RSM Performance'[RSMP YAGO Volume]<>"Jarrod Patrick", 'RSM Performance'[RSMP YAGO Volume]<>"Nigel Smith")

 

Any advice is greatly appreciated

 

 

 

 

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

    ?

     

11 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Anonymous 

    try SUMX()

    test = CALCULATE(SUMX(Table, Table[YAGO Combined Volume])*1.02, 'RSM Performance'[RSMP YAGO Volume]<>"Russell Curtis", 'RSM Performance'[RSMP YAGO Volume]<>"Jarrod Patrick", 'RSM Performance'[RSMP YAGO Volume]<>"Nigel Smith")
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I've tried the formula below but giving an error message

       

       
      • az38's avatar
        az38
        Community Champion
        6 years ago

        Anonymous 

        pardon, my prev statement has a mistake plus try FILTER

        test = CALCULATE(SUMX('RSM Performance', 'RSM Performance'[YAGO Combined Volume]*1.02), FILTER(ALL('RSM Performance'), 'RSM Performance'[RSMP YAGO Volume]<>"Russell Curtis" && 'RSM Performance'[RSMP YAGO Volume]<>"Jarrod Patrick" && 'RSM Performance'[RSMP YAGO Volume]<>"Nigel Smith"))