Forum Discussion
Help with disconnected slicer required
Hi guys. I'm relatively new to disconnected slicers, but I get how they work and have been able to build a timeframe slicer that does what I want it to do. However, whilst all of my values show up...
It is hard to comment without seeing the model and data, but for now, can you try using an iterator? Something like the formula below
TargetCostMeasure =
SUMX (
VALUES ( Dates[Month] ),
IF (
AND (
CALCULATE ( MAX ( Dates[RMI] ) ) >= DateSlicer[SlicerMinValue],
CALCULATE ( MAX ( Dates[RMI] ) ) <= [SlicerMaxValue]
),
CALCULATE ( SUM ( Dates[Target Net Costs] ) ),
BLANK ()
)
)(and the reason is that there is no context for the measure in that visual, like Greg_Deckler said.).
Greg_Deckler
Community Champion
Community ChampionI'm guessing that the reason is that in the context of the visual, there is no date reference to check min and max on and thus there is nothing being pulled back in terms of data and thus blank.