Shared measure is a measure that is calculated by using a level-based measure. There's no difference when you compare it with other logical measures.
- We're going to create a new logical column in the fact table and again we're going to define a formula. In the formula, we're going to use a level-based measure as well. The formula I used in my demonstration is as follows. It's going to calculate the percentage of a month level sales amount with the total year level sales.
(Sales.Fact_Sales.Dollars / Sales.Fact_Sales.Year Total Dollars ) * 100
This time we're not going to change anything in the Levels tab. We're going to leave the settings as it is.
- As usual, the new logical column should be added to the Presentation ...