Sorting a stacked bar chart with multiple measures and one dimension

[PaoloGuerra]

Hi all,

i have  bar chart with 6 measures and one dimension.

- Each measure can have values: true and false

- I count only the measures with value "True".

Count({<MEASURE1={"True"}>}MEASURE1)

- The dimension name is: "Db User Name"

I need to sort by total value and this is the reale situation

Can we help me please?

[Gysbert_Wassenaar]

Change the Sorting option of the first dimension to Custom and then Enable the option Sort by expression. Then use the same expression as in your measure as sorting expression. Change the sorting order to Descending.

[PaoloGuerra]

Hi @Gysbert_Wassenaar ,

thanks for your help.

i've already tried in that way before writing this post, but it doesn't work. Maybe I'm wrong.

The dimension is:

=DB_User_Name_Comb_Machine_Learning

The measures:

The sorting:

I have enabled the option "Sort by expression" with the same expression of dimension. It's correct?

=DB_User_Name_Comb_Machine_Learning

And "order to Descending". Is italian version. But doesn't work.

[Gysbert_Wassenaar · Accepted solution]

Ah, one dimension and lots of expressions. Ok then you need something like

rangesum( expression1, expression2, ...., expressionN )

[PaoloGuerra]

Thank you very much!

It works!