I'm not sure I know what the desired outcome is. However, I have reattached the workbook with the Order ID being put in order based on the AVG(Discount). By creating a set with Order ID and Order Priority and placing it on the rows shelf between Order ID and Order Priority will allow there to be some value in every row for both columns. Then, Order Priority can be sorted.
Hope this helps!