Forum Discussion

ikkew's avatar
ikkew
Icon for Advocate I rankAdvocate I
7 years ago
Solved

Wrong column totals (table)

Hi, I've been trying to display a simple table with total values but I seem to have an issue. My totals seem to be incorrect. What could be the issue here? Very willing to provide more info if nesc...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    Can you try this for MIN:

    Min = SUMX(VALUES(Artikel[ArtikelId]), CALCULATE(SUM(ArtikelM[Aantal]) * MIN(ArtikelM[MinEenheid])))
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
7 years ago

Ok, i understand now.  There is a bracket in the wrong place in your version of my measure. It should be

MinChilli = SUMX(ArtikelM, ArtikelM[Aantal] * ArtikelM[MinEenheid])

ikkew's avatar
ikkew
Icon for Advocate I rankAdvocate I
7 years ago

You're right, my mistake and my apologies.

Your answer should've been the accepted answer since it was first.

Thank you for helping me out!