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: