How to calculate different measures at different levels
I need to create a dashboard in the below format.
Sales by Month
Sales by Year
In this dashboard the Sales by Month measure will be calculated based on Year and Month, i.e., in the example above, for Jan 2017 the sales is 100, for Jan 2016 sales is 300 etc. The Sales by Year value needs to calculated based on the year only, i.e., in the example above, the total sales for 2017 for all the months Jan-Dec is 500, the total sales for 2016 for all the months from Jan-Dec is 1000. For Sales by Year, the value always needs to show the sum for all 12 months irrespective of the months selected in the filter.
Can anyone please let me know how to calculate the Sales by Year value.
Re: How to calculate different measures at different levels
In this part the user has selected only Jan and Feb in the filter. so data is shown only for the two months. But the Sales by Year value need to the sum of all months from Jan-Dec always irrespective of the months selected in the filter. So, I have put here the value for 2017 as 500 which is Jan+Feb+Mar+Apr+May+Jun+Jul+Aug+Sep+Oct+Nov+Dec.