Forum Discussion

celen's avatar
celen
Frequent Visitor
2 years ago
Solved

Matrix and subtotal

Hi, 

 

I got this matrix with Value 1 and Value 2. Value 3 is depending if the date is before or after given date. In below example if date is <= 2023-12-31, Value 3 should be same as Value 2 otherwise Value 1. So far no problem...

...but how should re-write the measure for Value 3 in order for the subtotal on month level to be correct? ( Jan, Feb ... should also be 28.581)

 

 

  • tamerj1's avatar
    tamerj1
    2 years ago

    Hi celen 
    You SELECTEDVALUE 'Calendar'[Date] would return blank at month level as there is no single value of date. You need to replace with MIN

    Value 3 =
IF (
    MIN ( 'Calendar'[Date] ) <= SELECTEDVALUE ( CalendarActualForecast[Date] ),
    [Value 2],
    [Value 1]
)

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    2 years ago

    Hi celen 
    You SELECTEDVALUE 'Calendar'[Date] would return blank at month level as there is no single value of date. You need to replace with MIN

    Value 3 =
IF (
    MIN ( 'Calendar'[Date] ) <= SELECTEDVALUE ( CalendarActualForecast[Date] ),
    [Value 2],
    [Value 1]
)