company average
1 Topic
ALL with ALLEXCEPT
Hi All, I'm getting the wrong figure with a formula using ALL and ALLEXCEPT to create a Company Average even though I think the formula is correct... Please help!! My table called Stock contains the measures (a fact table only) and dimensions join to it giving the Calendar and Store detail. I've got Measure 1 that is a simple sum(Value1)/sum(Value2) calculation that's presented by Region on a chart. Region "Unknown" is filtered off. The page is filtered on the last 91 days using the Calendar's Relative Date field. Measure 2 attempts to create a Company Average that only takes into account the filter on the Calendar table, but ignores any other, using all available data. The formula I wrote is this: Measure 2= CALCULATE([Measure 1],ALL('Stock'),ALL('Branch'[Regional Manager Name]),ALLEXCEPT('Calendar Date Detail','Calendar Date Detail'[Calendar Relative Date Number])) The figure that I'm getting however is wrong and no matter what I change it's still wrong. Any suggestions?Solved3.5KViews0likes7Comments