Sorting Calculation Groups

DAX DAX Calculations
1

Hi All,

Is there a way of sorting calculation group columns/fields within a table / matrix visual? For example, I have 3 measures within the calculation group i.e. revenue, quantity, transactions and these are in a table visual but I would like to also sort by the revenue, quantity or transactions etc in descending or ascending order. Currently, the sort is by alphabetic order of whatever filter context I would have chosen and in this case product names.

Thank you.

Harvey

2

Hi @Harvey

This is a little bit trick, please read this post:

2 Likes
3

Thanks @jbressan this was very helpful, will try it out.

4

Hi @Harvey, did the response provided by @jbressan help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

1 Like
5

Yes. Solved! Thanks