Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
3 years ago

Hello Anonymous,

 

It's possible that some SKUs are missing the Fcst CM value because they don't have any entries with that classification in the selected period.

 

To display all values at the SKU level, you may need to modify your measures to explicitly filter for the selected period at the SKU level, rather than relying on the ALL() function to remove the Classification filter.

Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
3 years ago
calculate 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])
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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