Forum Discussion

lawadaa's avatar
lawadaa
Helper I
3 years ago

measure is returing wrong total value in table visual

hi everyone

 

i have created a measure that calculates the sales agents incentive. it's returning value per row correct but the total value in the table visual is wrong

 the measure is :

new agent incentive = CALCULATE([new commissin sum]*max('Agent Rate Key'[Agent Rate]))
 
new commission sum measure :
new commissin sum = Sumx(Summarize('categories trans','categories trans'[categories summarize],'categories trans'[base type without zeed], "_1", [new commission calculation]), [_1])
 
new commission calculation measure :
new commission calculation = IF([new achiev %]<= 0.8999,0, IF(([new achiev %]>=.90 &&[new achiev %]<=.9499),300-(.1*300), IF([new achiev %]>=.95 &&[new achiev %]<=.9999,300-(.05*300), IF([new achiev %]>=1 &&[new achiev %]<=1.09,300, IF([new achiev %]>= 1.1 &&[new achiev %]<=1.1999,300+(.1*300), IF([new achiev %]>=1.2 &&[new achiev %]<=1.29999,300+(.2*300),IF([new achiev %]>=1.3,300+(.3*300),0)))))))
"DAX"
"subtotal
@sumx
Calculate Sum
Cumulative Total
DAX Total

5 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    Hi lawadaa 
    Please try

    new agent incentive =
SUMX (
    SUMMARIZE (
        'Agent Rate Key',
        'Agent Rate Key'[T_NAME],
        'Agent Rate Key'[categories summarize],
        'Agent Rate Key'[base type without zeed]
    ),
    [new commissin sum] * CALCULATE ( MAX ( 'Agent Rate Key'[Agent Rate] ) )
)
    • lawadaa's avatar
      lawadaa
      Helper I
      3 years ago

      it's still returing the same total198. correct total should be 112.5

       

      • tamerj1's avatar
        tamerj1
        Community Champion
        3 years ago

        lawadaa 
        Would you please paste a screenshot of the code that you have used?