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 want to be set to 0,- EUR. That´s what I have achieved with my measure EUROffenTest. At line level everything works ok, however, the total is not correct. I am expecting a bigger value for the EUROffenTest than for SUM(EUROffen).

 

 

 

I tried the following code for the measure:

 

EUROffenTest = VAR EUROffenZeilen = SUMX(ABVorgangspositionenMonate, ABVorgangspositionenMonate[EURBestellt]-ABVorgangspositionenMonate[EURFakturiert])

VAR test = IF(EUROffenZeilen<0, 0, EUROffenZeilen)
RETURN IF(HASONEFILTER(ABVorgangspositionenBasis[Projekt]), test, .....)
 
I am not sure what to write for the total.
 
Thanks for you help!
 
Chris
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.

4 Replies