Can Measure Result be used for Creating a Chart?

We are currently categorizing every combination of dimensions as either headwing or saving on a row level basis. Using the image above as an example this means that within the group "A" there one or more rows that are considered "Headwings" as well as one moremore that are considered "Savings". Since the Headwings/Savings calculation is made before any calulation in the table is done the column acts as a category, telling you that within the specific group "A" there is a specific sales gap related to the categories.

If you're looking for a categorization that is done in the table calculation you will need to use a measure instead of a calculated column. Since the measure needs to rely on the sales gap the gap also needs to be calculated with a measure. 

Sales Gap = [Sales] - [Sales 2019]

Sales Trend = IF( [Sales Gap] >= 0 , "Savings" , "Headwings" )

But keep in mind that measures are dynamic and will calculate dependant on the dimensions they are evaluated with. As you are currently only using the "Group" dimension in your table, this essentially means that the sales gaps will be a comparison of the 2020 / 2019 sales for each group. 

Hope this helps, let me know how it goes. 

/ J