Is there a way to make one table appear blank if a slicer is selected?

[KyleAdam]

Sorry for making this confusing, but as you can see below, I have 4 tables (on the right hand side) and two slicers on the left hand slide which are labelled "Deals" and "Customers" 

Every Customer has a Deal, so if you were to search a Customer, the Deals will filter to that customer, as would the tables next to it (with the correct information). However, when I filter the Deals, everything works but one, the Projects (The top table). This is because there is no relationship between Deals and Projects. So instead it will only show me Projects that are related to that Customer (of the deal) which will affect the math in the tables. 

Is there any way I can make the Projects table BLANK whenever I select a Deal slicer? That would be really helpful. 

[parry2k]

@KyleAdam as per the screenshot, you didn't filter Is Deal Selected for value 1, how do you expect it to work until I'm missing something.

Also, I recommended checking if Is Deal Selected working as expected by adding a card visual, and you didn't even comment on that. 

[KyleAdam]

Thank you @parry2k it works now. 

Apologies I didn't fully understand the code and instruction that you gave me. You did originally say KPI though and I did try that. Obviously I wasn't aware you added in the 1 on the filter. 

[parry2k]

@KyleAdam can you share the screen shot where you added the visual level filter and measure expression.

Put a KPI Card visual and put this measure and check on Deal selection if value changes to 1 and on no selection it goes back to 0

[KyleAdam]

Hello @parry2k 

Here is the filter visual for the Project table: 

And here is the measure you gave me: 

Just the exact same as the one you gave except for obviously, the Deal Name location. 
And here is the KPI example, it doesn't appear to be working here either:

[parry2k · Accepted solution]

@KyleAdam add a measure to check if a Deal value selected and then use this measure as a visual level filter on the project table where this measure value is 1

Is Deal Selected = IF  ( HASONEFILTER ( YourTable[DealColumn] ), 1, 0 )

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[KyleAdam]

Hi thank you for the reply @parry2k 

I just added that measure and filtered it to the Deal slicer (the column is Deal Name), however, sadly it's still not working. I've put it as a filter on the visual area and there has been no change sadly. It still isn't blank when I select a Deal, which is ultimately what I want.