Card turns transparent or list appears when selection in TABLE is made, not SLICER

[Anonymous]

I've got a new challenge.

I have a table of data, [Table A] with a distinct count of names in it, by month. E.g:

Period           Names Count

Jan 2021       8

Feb 2021      6

Mar 2021      4

Apr 2021      7

I have a second table, [Name Table] with the actual names as a list. E.g:

Names

Jessica B

Maria F

Adam C

Michelle A

Anthony S

So, if I select the top row of [Table A] then [Name Table] reduces to those 8 people. If I select the third row in [Table A], then [Name Table] reduces to 4 people.

But, if click outside of [Table A] then [Name Table] just shows all names. A long and pointless list.

I want to make [Name Table] disappear until someone has selected inside [Table A]. 

Now, I know how to do this if a slicer is used, but not when it's just a dynamic, temporary table selection type filter. 

I've tried a few things to no avail. Is my dream at all possible? Or is DAX limited to only liking slicer filters? 

[v-angzheng-msft]

Hi, @Anonymous 

May I ask if your problem has been solved? Is the above answer helpful to you?

If  it does, could you please mark the post which helps as Answered since it is working now?  It means a lot to me, and it will help the others in the community find the solution easily if they face the same problem with you.

Could you please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion if the problem has not been resolved?

Thank you.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

Try to create a measure like this:

_show =
IF (
    ISFILTERED ( 'TableA'[Period] ),
    IF (
        CALCULATE (
            MAX ( 'Names'[Date] ),
            FILTER ( 'Names', 'Names'[Names] = MAX ( 'Names'[Names] ) )
        )
            IN ALLSELECTED ( TableA[Date] ),
        1,
        0
    ),
    -1
)

And then show items when value is 1 in filter pane.

So the result:

Please refer to the attachment below for details. Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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

[amitchandak]

@Anonymous , I am getting lost in description, are you trying to hide show card based on some selection?

example- use in conditional formatting using the filed value

if(isfiltered(table[Column]) ,"#FFFFFF00", "FFFFFF")