Visuals Blank until Related Slicer Value chosen

[jwbtkd3]

Hello,

I have two tables that are related to each other. The first is a 'Contacts' table containing [Full Name], [Employer], [Job Title], [Email]. The second table, 'Connections', contains [Connected to], [Email From], [Role To]. 'Connections', is related to the 'Contacts' in a many (Connections) to one (Contacts) bi-directional relationship by [Email From]/[Email].

I am looking to have my dashboard items blank until a Slicer for [Connected to] value is chosen. The dashboard visuals are all information from the 'Contacts' table, with nothing from 'Connected to'.

 Ideally, the table on the right will be blank until a value from the drop-down slicer is chosen.

On a different dashboard item, I used a solution I found here, creating a measure using IF and ISFILTERED/HASONEFILTER and applying that as a visual level filter. However, for that item, all the information is contained on the one table. I have a feeling RELATEDTABLE and CALCULATE needs to be used for my problem, but cannot figure it out. Can someone point me in the right direction?

Thank you 

[v-ljerr-msft · Accepted solution]

Hi @jwbtkd3,

According to your description, you should be able to use the formula below to create the measure and applying that as a visual level filter to get your expected result.

Measure_Email =
IF (
    ISFILTERED ( Connections[Connected to] ),
    IF ( HASONEVALUE ( Contacts[Email] ), VALUES ( Contacts[Email] ) )
)

Regards

[jwbtkd3]

That worked perfectly, thank you!