Forum Discussion

aobubo85's avatar
aobubo85
New Member
3 years ago
Solved

CONDITIONAL or NESTED SUMIF

Hi All,   I am trying to achieve the result in the screenshot below in a Power BI Report but having trouble with the DAX. The aim is to show an aggregate Overdraft position for parent accounts by a...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi aobubo85 

    please try

    Net Overdraft =
    SUMX (
    SUMMARIZE ( Table2[Account], Table2[Account], "@GrossDraft", [Gross Overdraft] ),
    IF ( [@GrossOverdraft] < 0, [@GrossOverdraft], 0 )
    )

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi aobubo85 

please try

Net Overdraft =
SUMX (
SUMMARIZE ( Table2[Account], Table2[Account], "@GrossDraft", [Gross Overdraft] ),
IF ( [@GrossOverdraft] < 0, [@GrossOverdraft], 0 )
)

aobubo85's avatar
aobubo85
New Member
3 years ago

Thank you tamerj1. This worked perfectly.