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

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
    )

Forum Discussion

Dax if/then divide statement

Related content

Dax Statement If all selected then ...... else if filtered then .......

Help with adding if then statement?

if then else

If then statement with embedded calculation

DAX IF/THEN Statement