Forum Discussion

JB's avatar
JB
Helper II
4 years ago

Date Filtered Calculation Not Working As Expected

I have three measures on a report that calculate stock value and the change in stock value on a monthly basis. They need to be receptive to two slicers; a date slicer and a Component Type slicer. The...
CALCULATE
Filter
if
Slicer
sum
variable
JB's avatar
JB
Helper II
4 years ago

Taking into account how over engineered my original DAX formulas were, I've made a much simpler version but it still returns (Blank). 

Simplified = 
SUMX(FILTER('Component Type Nov - Jan', 'Component Type Nov - Jan'[Date] = SELECTEDVALUE('Component Type Nov - Jan'[Date])-1), 'Component Type Nov - Jan'[total stock sum])

Removing the -1 returns the correct value but including -1 breaks it, even though SELECTEDVALUE('Component Type Nov - Jan'[Date])-1) returns the correct month when used on its own in a call out card. 

No idea why.