Forum Discussion

Icon for Helper I rank

Helper I

9 years ago

DAX Measure reference error

Dear Colleagues, I get an error when I am referencing the following Measure. CurrentMonth:=CALCULATE( MONTH(Max(Merge1[Date])), Merge1[SalesR2017]<>0) The value of this CurrentMonth mea...

Anonymous

Not applicable

9 years ago

Try this one:

Measure = CALCULATE(
                                       sum(Merge1[SalesR2017]),
                                       MONTH(Merge1[Date])=MONTH(Max(Merge1[Date]))
                    )

ViorelCa
Helper I
9 years ago
Hi Anonymous

The same error.

Actually I am doing this in PowerPivot Excel 2013 and the error does not not have a message, it just shows #ERROR
- Dog
  Responsive Resident
  9 years ago
  Hi,
  
  I wonder if it's having an issue build the query to run.
  
  does this work any better.
  
  Sales2017Rcurrent:=
  var lastmonth = MONTH(max(Dates[DateKey]))
  return
  CALCULATE(sum(Merge1[[SalesR2017]), MONTH(Merge1[Date]) = lastmonth, Merge1[SalesR2017] <> 0)
  
  actually you don't need to last part as summing a zero doesn't matter
  
  Sales2017Rcurrent:=
  var lastmonth = MONTH(max(Dates[DateKey]))
  return
  CALCULATE(sum(Merge1[[SalesR2017]), MONTH(Merge1[Date]) = lastmonth)
  
  Dog
  - Anonymous
    Not applicable
    9 years ago
    Dog ViorelCa
    Sorry for my measure, didn't double check it.
    So, the measure which works for me is:
    MEASURE = CALCULATE(sum(Merge1[SalesR2017]); LASTNONBLANK(Merge1[SALESR2017];">0"))
    btw, do use a time table (aka calendar)?

Related content