How to create a measure that consider a lower level of granularity

[marcocapo]

Hi All,

I'm trying to create a report for calculating a KPI. The data behind the report are downloaded in excel at a determined level of granularity, so I have Region -> Site -> Material -> Customer. I download this granularity because I need it in the same report too. 

Is there a possibility to create a measure that not consider the customer? 

For Example:

I have data like the following ones.

So, the granularity of the quantity "Actual Qty Month" and of the "Adj. Demand Manager Qty Lag" is given by the combination of Location Description, Material, Customer and Time Period.

The error is calculated as "ABS(Adj. Demand Manager Qty Lag - Actual Qty Month)" and is calculated for each row. 

I'd need to calculate the error with the same formula --> ABS(Adj. Demand Manager Qty Lag - Actual Qty Month), but just considering Location Description, Material and Time Period. So, aggregating the quantities just excluding the Customer for this measure.

Is it possible to create a measure like this? 

Hope to been clear. 

Thanks,

Marco

[Ashish_Mathur]

Hi,

I cannot understand your expected result (second table).  How did you get the combinations of 2C, 3A?  Also, why is 2C being repeated?  Please explain.  

[lbendlin]

Read about the usage of REMOVEFILTERS()