Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

Display values in a table only when a filter is used

Best regards

I'm requiring you to have a table show me the values of the data only when they use the segmenter filter, try using a measure and adding a filter to the table visual this way.

Measure:

HIDE DATA = IF(ISFILTERED(DATA[SOLICIFIED]),1,0)
Filter:

When I test the measurement on a table it gives me the value of 1 for each row and I don't get the result I expect.

How could you achieve the expected result?

Thank you very much for your cooperation.

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Syndicate_Admin 

     

    Maybe you can try this:

    I create a set of sample data:

    Then i add a measure:

    Hide Data = IF(ISFILTERED('Table (2)'[%value]),MAX('Table (2)'[%value]))

    The result is as follow:

     

    Best Regards,

    Zhengdong Xu

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

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Syndicate_Admin 

     

    Maybe you can try this:

    I create a set of sample data:

    Then i add a measure:

    Hide Data = IF(ISFILTERED('Table (2)'[%value]),MAX('Table (2)'[%value]))

    The result is as follow:

     

    Best Regards,

    Zhengdong Xu

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