Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filtering issues while calculating coloumn

Hello everyone,   i want to create a calculated coloumn which should show a sum of an amount based on the customer id and the amount the customer has to pay which is related to a "reason you have t...
Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    Try it;

    HL_EP =
VAR rpue_grund = 'RPÜ_Grund'[iid]
RETURN
    CALCULATE (
        SUM ( 'RPÜ_Report'[Betrag] ),
        FILTER ( ALLSELECTED ( 'RPÜ_Report'[ID] ), 'RPÜ_Report'[ID] IN rpue_grund )
    )

     

    zz_ep =
CALCULATE (
    SUM ( 'RPÜ_Report'[Betrag] ),
    FILTER ( ALLSELECTED ( 'RPÜ_Report' ), 'RPÜ_Report'[ID] = 11 )
)


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Anonymous ;

Try it;

HL_EP =
VAR rpue_grund = 'RPÜ_Grund'[iid]
RETURN
    CALCULATE (
        SUM ( 'RPÜ_Report'[Betrag] ),
        FILTER ( ALLSELECTED ( 'RPÜ_Report'[ID] ), 'RPÜ_Report'[ID] IN rpue_grund )
    )

 

zz_ep =
CALCULATE (
    SUM ( 'RPÜ_Report'[Betrag] ),
    FILTER ( ALLSELECTED ( 'RPÜ_Report' ), 'RPÜ_Report'[ID] = 11 )
)


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.