Forum Discussion

GKJARC's avatar
GKJARC
Icon for Resolver I rankResolver I
2 years ago
Solved

Filter matrix only 1 row in matrix

Hi everyone, I have a matrix table with a multiple row hierarchy. All the rows should appear like usual, even if the pertinent values are blank or 0. Except for the last row in the hierarchy, if t...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    AUDISU  Thanks for your contribution on this thread.

    Hi GKJARC ,

    You can follow the steps below to get your expected result, please find the details in the attachment.

    1. Create a measure as below

    Measure = IF ( SUM ( 'Table1'[Amount] ) = 0, BLANK (), SUM ( 'Table1'[Amount] ) )

    2. Replace the field in Values option with the above new measure just as below screenshot

    Best Regards

  • GKJARC's avatar
    GKJARC
    2 years ago

    Hi Anonymous ,

    The help is appreciated however it is actually not a solution to what was asked. Only the level of consumption should be filtered, not the legs themselves. The offered solution removes also the legs if there is 0 consumption. as you can see, the leg of 12-3 is entirely missing from the visual with the proposed measure.
    The legs should be shown even when there has been no consumption in a leg, it is still an event that is part of a voyage therefore it is in this case important that it remains visible.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

AUDISU  Thanks for your contribution on this thread.

Hi GKJARC ,

You can follow the steps below to get your expected result, please find the details in the attachment.

1. Create a measure as below

Measure = IF ( SUM ( 'Table1'[Amount] ) = 0, BLANK (), SUM ( 'Table1'[Amount] ) )

2. Replace the field in Values option with the above new measure just as below screenshot

Best Regards

GKJARC's avatar
GKJARC
Icon for Resolver I rankResolver I
2 years ago

Hi Anonymous ,

The help is appreciated however it is actually not a solution to what was asked. Only the level of consumption should be filtered, not the legs themselves. The offered solution removes also the legs if there is 0 consumption. as you can see, the leg of 12-3 is entirely missing from the visual with the proposed measure.
The legs should be shown even when there has been no consumption in a leg, it is still an event that is part of a voyage therefore it is in this case important that it remains visible.