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
Icon for Community Champion rankCommunity 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"))

 

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