Measure result changed when add a sort column.

[YunJ]

Hi,

I create a measure as following:

Now I want to sort Sub-Category. So I add a index column in the Dim Sub-Category table, and sort Sub-Category by index.

But as you can see, the result of the measure I created changed.. which is not what I want.. 

Thanks a lot for your time.

[az38 · Accepted solution]

@YunJ 

try

Total_red_incluBLANK = 
CALCULATE(SUM(MU_red[Sales]),ALL('Sub-Category'[Sub-Category], 'Sub-Category'[Index]))

[YunJ]

Thanks a lot @az38