Forum Discussion

mr_reygan's avatar
mr_reygan
Frequent Visitor
5 years ago
Solved

Measure showing incorrect total

Hi,   I have a measure which calculates cost based on parameters. At the row level, the cost is correct. But the totals show incorrect results.   The expected results are: Drinks - 13 Fruit - 5...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Please try this expression that references your existing Cost measure.  Replace Table with your actual table name.

     

    Cost SUMX = SUMX(VALUES(Table[Category]), [Cost])

     

    Regards,

    Pat

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

mr_reygan , Try like

sumx(Summarize(Table, Table[category], "_1",[Cost]),[_1])

  • mr_reygan's avatar
    mr_reygan
    Frequent Visitor
    5 years ago

    @amitchandak , great! it worked! 🙂

    Do I always have to create 2 measures? 1 for row level and another 1 for totals?