cancel
Showing results for
Did you mean:
Helper III

Ranking of matrix

Hi All,

My data is in a matrix (like below) and I would like the ranking on TYPE to be fixed 1) shoes 2) clothes 3) accessories 4) kitchen but when i expand the + sign, i would like the measure to rank by descending order. is this even possible? thanks alot for the valuable help 🙂

My dataset looks like this:

1 ACCEPTED SOLUTION
Community Support

Hi @evko ,

You will need to create another measure to calculate the value by type.

For example:

``````Measure = SUM('Table'[value])

Measure 2 = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[type]))``````

Then use ISFILTERED() function to get different rank.

``````Measure 3 =
var _unexpand = RANKX(ALLSELECTED('Table'),[Measure 2],,ASC,Dense)
var _expand = RANKX(ALLEXCEPT('Table','Table'[color]),[Measure],,DESC)
return
IF(ISFILTERED('Table'[color]),_expand,_unexpand)``````

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
4 REPLIES 4
Community Support

Hi @evko ,

You will need to create another measure to calculate the value by type.

For example:

``````Measure = SUM('Table'[value])

Measure 2 = CALCULATE(SUM('Table'[value]),ALLEXCEPT('Table','Table'[type]))``````

Then use ISFILTERED() function to get different rank.

``````Measure 3 =
var _unexpand = RANKX(ALLSELECTED('Table'),[Measure 2],,ASC,Dense)
var _expand = RANKX(ALLEXCEPT('Table','Table'[color]),[Measure],,DESC)
return
IF(ISFILTERED('Table'[color]),_expand,_unexpand)``````

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
Solution Supplier

measure=IF(ISINSCOPE([Colour]),_descRank,_ascRank)

Helper III

Hi, sorry what is _descrank? is that also a measure?

Solution Supplier

Announcements