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

This... seems to work!

Could you elaborate on why your measure

 

Min = SUMX(VALUES(Artikel[ArtikelId]), CALCULATE(SUM(ArtikelM[Aantal]) * MIN(ArtikelM[MinEenheid])))

works, compared to

 

Min = SUMX(ArtikelM, ArtikelM[Aantal]) * MIN(ArtikelM[MinEenheid])

I can't thank you enough though!
Same for the others who tried to help me and pointed out the source of the issue!

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

Generally working on Column Totals can become very tricky sometimes on PowerBI.

 

Values function returns the MIN of the each value in the field specified in the function. In this case 'Artikel[ArtikelID]'.

Without it 'total' takes the min across all ArtikelIDs 

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hello again,

    I see that the issue is sorted now which is great.  Can you tell me what happened when you put my measure in to your pbix because i have just re-tested (fresh copy of your pbix, added MinChilli measure) and it all worked great?

    • 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])