Forum Discussion
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...
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 )
Are Variance and Budgets columns or measures?
Hello FreemanZ, Variance and Budgets are measures.