Forum Discussion

ivamsikrishna's avatar
ivamsikrishna
Frequent Visitor
2 years ago
Solved

Hierarchy sorting

Team, we are trying to develop typical FI report which required detailed level of custom sorting order to match client needs. Below is the sample data.  Segment Main Sub Order Number Desc Se...
Need Help
  • CoreyP's avatar
    CoreyP
    2 years ago

    Maybe I'm a little lost. From what I understand, the client doesn't care how any of the other fields are sorted, they only want to see the visual sorted by order number in ascending order? Can you confirm and also show a screenshot of your matrix visual and the fields included?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ivamsikrishna ,

 

Please try code as below to create measures.

Segment 1 =
CALCULATE (
    SUM ( 'Table'[Segment1] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[Sub], 'Table'[Desc] ),
        'Table'[Segment] = MIN ( 'Table'[Segment] )
    )
)
Segment 2 =
CALCULATE (
    SUM ( 'Table'[Segment1] ),
    FILTER (
        ALLEXCEPT ( 'Table', 'Table'[Sub], 'Table'[Desc] ),
        'Table'[Segment] = MAX ( 'Table'[Segment] )
    )
)

Result is as below.

 

Best Regards,
Rico Zhou

 

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