Forum Discussion
Slicer and problem with measure
Dear gurus, am having an issue with measure providing correct result at aggregated level but missing to display values at detailed level. My database is simple: SKU Classification Quanti...
Sahir_Maharaj
Super User
Super Usercalculate total current forecast =
Calculate(
SUM ('Demand Database'[Quantity]),
FILTER('Demand Database',
'Demand Database'[Classification]="FCST Curr Month" &&
'Demand Database'[Year]=SELECTEDVALUE('Demand Database'[Year]) &&
'Demand Database'[Month]=SELECTEDVALUE('Demand Database'[Month])
)hello Sahir_Maharaj and thanks for your suggestions.
I tried with your formula with FILTERS, it doesn't work at all. The slicer on the comparison measure is blocking the measure to take the values of current month, so the query is totally empty.
I still believe that something like ALL function should be used to remove the slicer effect.
moreover, by using ALL function, at least I can extract some values at SKU level but again I have missing values if I select more than one month for the extraction of values - but the total is always correct so am wondering if there's any conflict between the slicer and the visual.
if you've any other suggestion I'm happy to tried it out.
M