Forum Discussion

JWE's avatar
JWE
Helper I
9 years ago
Solved

Sum of Measure wrong

Hi all   I need support in summarize a measure in my visualisation.   My scenario: I have allready merged three fact tables into one - called 'Fakten'. I have further a target table ('Ziele') fo...
Need Help
  • JWE's avatar
    JWE
    9 years ago

    Hi ghuys

     

    thanks for help, but nothing works nor a-"isfiltered" neither b-"sumx".

    Result of a and variation mostly shows nothing!?
    B-Sumx shows me the same values without correct sum.

     

    BUT... the hint to make an addition works. I suprised because I thougt of filtercontext etc.

    So my solution now is very simple, here combinded in one measure:

    Umsatz GiveMe5 =
    CALCULATE (
        SUM ( Fakten[Betrag] );
        USERELATIONSHIP ( Ziele[PK_VBG]; Fakten[PK_VDeb] )
    )
        + CALCULATE (
            SUM ( Fakten[Betrag] );
            USERELATIONSHIP ( Ziele[PK_VBG]; Fakten[PK_VDebGrp] )
        )

  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi JWE,

     

    Brilliant solution!:smileylol:

     

    In addition, could you accept your reply as solution to help others who may have similar issue easily find the answer and close this thread?

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi JWE,

 

In addition, could you try the formula below to see if it works?:smileyhappy:

 

! Umsatz GiveMe5 =
SUMX (
    'Fakten';
    IF (
        '1_Measures'[! Umsatz Deb] <> 0;
        '1_Measures'[! Umsatz Deb];
        '1_Measures'[! Umsatz DebGrp]
    )
)

 

Regards

JWE's avatar
JWE
Helper I
9 years ago

Hi ghuys

 

thanks for help, but nothing works nor a-"isfiltered" neither b-"sumx".

Result of a and variation mostly shows nothing!?
B-Sumx shows me the same values without correct sum.

 

BUT... the hint to make an addition works. I suprised because I thougt of filtercontext etc.

So my solution now is very simple, here combinded in one measure:

Umsatz GiveMe5 =
CALCULATE (
    SUM ( Fakten[Betrag] );
    USERELATIONSHIP ( Ziele[PK_VBG]; Fakten[PK_VDeb] )
)
    + CALCULATE (
        SUM ( Fakten[Betrag] );
        USERELATIONSHIP ( Ziele[PK_VBG]; Fakten[PK_VDebGrp] )
    )

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi JWE,

     

    Brilliant solution!:smileylol:

     

    In addition, could you accept your reply as solution to help others who may have similar issue easily find the answer and close this thread?

     

    Regards