Hello,
for simplicity, I will be referring to the Sales Cube (Sales - FoodMart Demo - eazyBI) in my question, as it is similar to my own cube.
Say we add the products to the rows, then we have the three product categories Drink, Food, and Non-Consumables, together with the three measures Store Sales, Store Cost, and Unit Sales. Say I now want to add a new measure, called Normalized Unit Sales. For this, I need to determine the minimum Unit Sales Value and the maximum Unit Sales value. Let’s just take the minimum value for an example. How would I approach calculating this? I would ideally like to do it through a new measure and MDX code.
Thank you!