Apologies if this is covered later in the course- I am still working my way through.
So I created a measure that shows the % of total sales that a model is contributing for 2020 and one for 2019, and then a measure that shows the movement, so model x contributed to 10% of sales and 5% in 2019, the increase is 5%.
As I sell a lot of products I want to create a visualisation that only shows movements above or below a set %, but it seems that you can’t apply a filter to a measure only tables?
The measure I have created is:
% Model Movement = CALCULATE([% of 2020 Sales] - [% of 2019 Sales])
Thanks in Advance