Forum Discussion

_chris_'s avatar
_chris_
Helper III
2 years ago
Solved

Measure: Wrong total

Hi,   I have a column (EUROffen) that sums up to the amount of 3.017 kEUR which is a positive value. The positive value comes from many positive values but I am also having negative values which I ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from Ashish_Mathur and Greg_Deckler  , please allow me to provide another insight:

    Hi, _chris_ 

    Regarding the issue you raised, my solution is as follows:

    1.First I have created the following table and the column names and data are the data you have given:

    2.Second, you can try the following code as a calculated column:

    EUROffenTest = 
VAR EUROffenZeilen='ABVorgangspositionenMonate'[EURBestellt]-'ABVorgangspositionenMonate'[EURFakturiert]
RETURN IF(EUROffenZeilen<=0,0,EUROffenZeilen)

    3.Then modify the way he aggregates:

    4.Here's my final result, which I hope meets your requirements.

    Please find the attached pbix relevant to the case.

     

    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

_chris_ First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

_chris_'s avatar
_chris_
Helper III
2 years ago

Hi Greg,

 

thanks for you reply; i have seen this page before. However, it is not working. Unfortunately, I did not give you the full context.

 

In fact, I am working with two tables and I guess that is the problem. For the Total, first I need to summarize the expression (EURBestellt-EUROffen) and decide whether the value is below zero or not. Finally, I need to summarize the intermediate results.

 

Still not sure how to do this.

 

Thx, Christian

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks for the reply from Ashish_Mathur and Greg_Deckler  , please allow me to provide another insight:

    Hi, _chris_ 

    Regarding the issue you raised, my solution is as follows:

    1.First I have created the following table and the column names and data are the data you have given:

    2.Second, you can try the following code as a calculated column:

    EUROffenTest = 
VAR EUROffenZeilen='ABVorgangspositionenMonate'[EURBestellt]-'ABVorgangspositionenMonate'[EURFakturiert]
RETURN IF(EUROffenZeilen<=0,0,EUROffenZeilen)

    3.Then modify the way he aggregates:

    4.Here's my final result, which I hope meets your requirements.

    Please find the attached pbix relevant to the case.

     

    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.