I am trying to find the difference between regional and national trends for different components. For example,
Allowed Dollars for Flu
I created a measure by doing Allowed Dollars for Flu divided by the trend denominator. So the trend for North would be 5/10 = 50%
I want to be able to take that trend for North (and every other region) and subtract the national trend (which would be (5+23+46+24)/(10+473+5789+1238) = ~13% so that for North you would have 50% - 13% = 37% and display it in a table like this:
Difference From National Trend
(the above difference values are just approximations, not exact). All of the values will change based on different slicers I have on my dashboard (ex. year) so I can't just have a static national trend that I reference.