Forum Discussion

ManuelGeiger's avatar
ManuelGeiger
Helper I
3 years ago
Solved

Keep specific rows in table visual

Hey all,   Is there a way to keep specific rows in a table visual no matter what you filter on? In my case I have a Bill of Material build with multiple levels which means a level 1 item could con...
Need Help
Tips and Tricks
  • ManuelGeiger's avatar
    ManuelGeiger
    3 years ago

    Hey MFelix ,

    Thanks for your answer. The data structure is just a table. Same as shown in the screenshot above

ManuelGeiger's avatar
ManuelGeiger
Helper I
3 years ago

Hey MFelix ,

Thanks for your answer. The data structure is just a table. Same as shown in the screenshot above

MFelix's avatar
MFelix
Super User
3 years ago

HI ManuelGeiger ,

 

Add a table for the slicer:

 

 

Try the following measure:

Repair Filter =
VAR temptalbe =
    FILTER (
        SUMMARIZE (
            ALL ( 'Table'[Serial number], 'Table'[Repair] ),
            'Table'[Serial number],
            'Table'[Repair]
        ),
        'Table'[Repair] = "X"
    )
VAR SerialNumber =
    DISTINCT ( SELECTCOLUMNS ( temptalbe, "SerialNumber", 'Table'[Serial number] ) )
RETURN
    SWITCH (
        SELECTEDVALUE ( 'Repair Slicer'[Repair] ),
        "Yes", IF ( SELECTEDVALUE ( 'Table'[Serial number] ) IN SerialNumber, 1 ),
        "No", IF ( NOT ( SELECTEDVALUE ( 'Table'[Serial number] ) IN SerialNumber ), 1 ),
        1
    )

Use the measure has a filter on the table and select has is not blank: