Forum Discussion

mariomyhanh's avatar
mariomyhanh
Icon for Helper I rankHelper I
3 years ago
Solved

Dax if/then divide statement

Please help, i'm fairly new to DAX and I am trying create a measure to look at a column ([Level 2]) in a table ('COA Structure') that contains "Total Operating Expense" then apply this division formu...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

mariomyhanh 
Please try

=
VAR Result =
    DIVIDE ( [Variance], [Budgets] )
RETURN
    SWITCH (
        SELECTEDVALUE ( 'COA Structure'[Level 2] ),
        "Total Operating Expense", IFERROR ( - Result, -1 ),
        "Total Operating Revenue", IFERROR ( Result, 1 ),
        Result
    )
mariomyhanh's avatar
mariomyhanh
Icon for Helper I rankHelper I
3 years ago

Thank you so much for all your help. Happy holidays.