Forum Discussion

Dtrain's avatar
Dtrain
Icon for Helper I rankHelper I
4 years ago
Solved

How to correct measure total

I’m stuck with this, the total is not showing the correct total. I am use the below measure and is working but for the total. Could anyone please help?   Total Bonus = VAR AllBonus = SUM('table 1'...
  • amitchandak's avatar
    4 years ago

    Dtrain , You need to use group by of visual and create thsi formula assume, you are using ApprovedCustId in visual or use somthing else which is on row or non summarized

     

    Total Bonus =
    VAR AllBonus = SUM('table 1'[Sale Bonus Amount])
    VAR ApprovedCust = SELECTEDVALUE('table 1' [ApprovedCustId])
    VAR BonusEx = CALCULATE(SUM('table 1' [Sale Bonus Amount]) *2, 'table 1' [Sale Bonus Amount] = AllBonus, 'table 1' [ApprovedCustId] = ApprovedCust)
    RETURN
    sumx(values( Table[ApprovedCustId]), IF(ISBLANK(ApprovedCust), AllBonus, BonusEx))

     

    for more than one column use summarize

     

    Total Bonus =
    VAR AllBonus = SUM('table 1'[Sale Bonus Amount])
    VAR ApprovedCust = SELECTEDVALUE('table 1' [ApprovedCustId])
    VAR BonusEx = CALCULATE(SUM('table 1' [Sale Bonus Amount]) *2, 'table 1' [Sale Bonus Amount] = AllBonus, 'table 1' [ApprovedCustId] = ApprovedCust)
    RETURN
    sumx(Summarize( Table[ApprovedCustId],"_1", IF(ISBLANK(ApprovedCust), AllBonus, BonusEx)),[_1])