measure did not work due to sort by column...

[ddpl]

While calculating max value in each row of matrix by...

max_row = MAXX(ALLSELECTED(tab[Col1]), [TotalCount])

without sorting Col1 by another column it will give what I want but with sorting Col1 by another column max_row value give me wrong value.

Any suggestions...

[Anonymous]

Hi @ddpl ,

Have you solved your problem?  If so, please kindly mark your answer as the solution to close the case.

If not, please provide more details with your desired output and pbix file without privacy information (or some sample data).

How to Get Your Question Answered Quickly 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ddpl · Accepted solution]

There are Col1, Col2 and a measure

Col1 is sort by Col2

so, I have to change my measure by ...

max_row = MAXX(ALLSELECTED(tab[Col1], tab[Col2]), [TotalCount])

SQLBI_BLOG_ON_THIS 

[amitchandak]

@ddpl , Not very clear.

You can not use measure as sort by column field.

Depending on visuals you can sort by Axis/Value.

On Table visual you can sort on more than one column by pressing shift