Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Automatic sum issues

Hello,   I have a problem with the automatic sum in the table below (even in graphique)  its sums the two last lines and after that it substract the first one only for the second columns   ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI Anonymous,

    It seems like a common measure total issue, does the sorties formula work with filters or special conditions? If that is the case, you can take a look at Greg's blog to know how to fix this:

    Measure Totals, The Final Word 

    Regards,

    Xiaoxin Sheng

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

Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandakth probleme is with the first line if don't select it ( have only the the two lines ST074, ST075) the total is correct but if filter by selecting the ST073, ST074 and ST075) the total is flase of the last column

    Centre   Entrées        Sorties

    ST073    128054,2    83364,26
    ST074    101311,34    100395,16
    ST075     56262,19     77785,65