Forum Discussion

kmagat's avatar
kmagat
Regular Visitor
6 years ago
Solved

Switching two measures

Hi,   I am having a problem in this measure. It says in the report: A table of multiple values was supplied where a single value was expected. So my target is to switch the measures when the invoic...
  • kmagat's avatar
    kmagat
    6 years ago

    I have already solve this problem. 
    Instead of using values, I used LASTNONBLANK.

    IF(LASTNONBLANK(DATE_INVOICE[MONTH], DATE_INVOICE[MONTH] < 4), [Dealer Base Tenured], CALCULATE([Dealer Base1], FACT_OFF_TAKE[DL_CLASSIFICATION] = "TENURED"))

kmagat's avatar
kmagat
Regular Visitor
6 years ago

I have already solve this problem. 
Instead of using values, I used LASTNONBLANK.

IF(LASTNONBLANK(DATE_INVOICE[MONTH], DATE_INVOICE[MONTH] < 4), [Dealer Base Tenured], CALCULATE([Dealer Base1], FACT_OFF_TAKE[DL_CLASSIFICATION] = "TENURED"))