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

themistoklis Same as with the SUMX approach for the "Min" measure: the same result :mansad:

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
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?