Forum Discussion
Calculating a variance
I'm trying calculate a variance and need help please. I'm trying to take submissions from Year 2018 subtract submissions from 2017, then divide that number by submissions from 2017. My problem is w...
Can anyone tell me why I'm seeing the error "The expression refers to muliple columns. Multiple columns cannot be converted to a scalar value." From this DAX?
Issue Variance = VAR Issued = SUM('Activity Counts6'[Issued])
VAR SUBS2017 = CALCULATE('Activity Counts6', 'Activity Counts6'[Year] = 2017)
VAR SUBS2018 = CALCULATE('Activity Counts6', 'Activity Counts6'[Year] = 2018)
RETURN DIVIDE (SUBS2018 - SUBS2017, SUBS2017)I was using a table name where I should've used the variable....
Issue Variance =
VAR Issued = SUM('Activity Counts6'[Issued])
VAR Issue2017 = CALCULATE(Issued, 'Activity Counts6'[Year] = 2017)
VAR Issue2018 = CALCULATE(Issued, 'Activity Counts6'[Year] = 2018)
RETURN DIVIDE (Issue2018 - Issue2017, Issue2017)