DAX Not Ordering

[m1nkeh]

Hi,

Hopefully, I'm doing something silly here... but can anyone tell me why my results won't order correctly?

Query:

EVALUATE
SUMMARIZE(
    Data
    ,'data'[item]
    ,"TotalAmount", Sum(Data[Amount])
)

Result:

Item    TotalAmount
Item1   3.95128609469091
Item2   4.24529815278904
Item3   4.19327473518058
Item4   4.11105035459714
Item5   4.41249125008144
Item6   4.17408171753715

Now, i tried to order them (as a set of test data to verify another TOPN function i'd written was working correctly), and couldn't get it to work...

New:

EVALUATE
SUMMARIZE(
    Data
    ,'data'[item]
    ,"TotalAmount", Sum(Data[Amount])
)
order by "TotalAmount"

Any ideas? - Workbook is here: http://1drv.ms/1TRizj8

As it turned out, the TOPN function i was using was also doing the same thing (incorrectly)...

Thanks,

 

[m1nkeh]

Urgh, solved it... feel like an idiot

EVALUATESUMMARIZE(
    Data
    ,'data'[item]
    ,"TotalAmount", Sum(Data[Amount])
)
order by [TotalAmount]