Forum Discussion

ctspradeep's avatar
ctspradeep
Regular Visitor
5 years ago
Solved

Matrix sort order based on second row

Hi,  I am trying to sort matrix second row but it's grouping first row and then sorting. Is there a way to override grouping and sort based on specific rows? Data:  Column Name Period Item V...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi ctspradeep ,

     

    My workround is use a measure to "replace" the Column subtotals,

    Please try this:

    Measure =
IF (
    HASONEVALUE ( 'Table'[Item] ),
    SUM ( 'Table'[Value] ),
    MAX ( 'Table'[Percentage] )
)

     The final output is shown below:

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi ctspradeep ,

 

My workround is use a measure to "replace" the Column subtotals,

Please try this:

Measure =
IF (
    HASONEVALUE ( 'Table'[Item] ),
    SUM ( 'Table'[Value] ),
    MAX ( 'Table'[Percentage] )
)

 The final output is shown below:

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