Forum Discussion

DamianDavies's avatar
DamianDavies
Frequent Visitor
2 years ago
Solved

Measure totalling issue

Hello Community 🙂   I am building a table to calculate the sales bonus earned by salesperson and quarter and having trouble with totalling a measure.     The possible sales bonus value is based ...
Measure Total with VAR and IF statements
Measure Totals
  • DamianDavies's avatar
    DamianDavies
    2 years ago

    I redeveloped the requirements using PowerQuery rather than measures.

     

    d;)

     

     

_elbpower's avatar
_elbpower
Resolver III
2 years ago

May be replace 

 

IF(
    'Incentives BDM Quarterly'[BDM % GP Target] >=1 && 'Incentives BDM Quarterly'[BDM % Sales Target] >=1,
    SUM('Incentives BDM Quarterly'[BDM Sales Band Bonus Qtr]),
    0
    )

 


With

 

SUMX(FILTER('Incentives BDM Quarterly',[BDM % GP Target] >=1 && [BDM % Sales Target] >=1),'Incentives BDM Quarterly'[BDM Sales Band Bonus Qtr])

 



What are you trying to achieve in the second measure and can you tell which one is table column, and which one is measure.

BDM Actual Bonus Qtr =
VAR __table = SUMMARIZE('Incentives BDM Quarterly', [Fiscal Quarter Year], "__value", [bdmActualBonusQtr])
RETURN
IF(
    COUNTROWS('Incentives BDM Quarterly') = BLANK(), BLANK(),
    IF(
    COUNTROWS('Incentives BDM Quarterly') = 1,
    'Incentives BDM Quarterly'[bdmActualBonusQtr],
    SUMX(__table, [__value])
    )
)



DamianDavies's avatar
DamianDavies
Frequent Visitor
2 years ago

Thank you for your reply, unfortunately, that didn't work.  It returns a blank column

 

 

Did I do it correctly?

 

The second measure is another attempt to get a total.