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

Similarly, your forecast for comparison measure could be modified as follows:

 

Calculate forecast for comparison =
Calculate(
SUM ('Demand Database'[Quantity]),
FILTER('Demand Database',
'Demand Database'[Classification]=SELECTEDVALUE('Demand Database'[Classification]) &&
'Demand Database'[Year]=SELECTEDVALUE('Demand Database'[Year]) &&
'Demand Database'[Month]=SELECTEDVALUE('Demand Database'[Month])
)