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])))
ikkew's avatar
ikkew
Icon for Advocate I rankAdvocate I
7 years ago

I'm currently refreshing my data, which takes some time (a lot of time unfortunatly +/- 2h) but I'll come back to this after it's done and probably update this reply with a screenshot. I think it's odd that it worked for you since nothing seemed to have happened on my side. Perhaps because I was trying out different things at the same time? I'm not sure..

 

Edit:

 

HotChilli Screenshots URL

I've made screenshots of

  • (themistoklis) the working statement, where 'Min' and 'Totale jaarlijkse besparing' are having the expected totals
  • (HotChilli) the grayed out statement where the statement can't be processed, the visual isn't updated here since I didn't save the staement
  • your statement edited to work in my .pbix, where 'Min' and 'Totale jaarlijkse besparing' are having the same totals as when I started this question, thus not changing anything in my visual
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!