Table Filtering Removing Null Values

[Anonymous]

The goal is have slicer filter to only reflect the confirmed selection. Currently, a slicer filter is selected and the table filters to highlight the elected selection but will also include null values for all other values within the table. Hoping to find a way to only have items selected via slicer filter to only reflect the elected selection. Below is sample data + current / expected output. 

Your advice will be greatly appreciated. 

Ex: List of NBA Players and the teams they played on >> Lets assume SLICER = Michael Jordan

Current Output: Notice that if Michael Jordan is selected, other players are still reflected on the table

NBA_Player	NBA_Team	Team_Count
Michael Jordan	Chicago Bulls	1
Michael Jordan	Washington Wizards	1
Kobe Bryant	Los Angeles Lakers
Steph Curry	Golden State Warriors
Total		2

Expected Output: Notice that if Michael Jordan is selected, only he is reflected on the table

NBA_Player	NBA_Team	Team_Count
Michael Jordan	Chicago Bulls	1
Michael Jordan	Washington Wizards	1
Total		2

[Sergii24]

Hi @Anonymous, are you using "NBA_Player" column for your slicer? Please share a screenshot of your model from PowerBI desktop. Thanks!

[Anonymous]

Hi @Sergii24 thank you for your support. My example is a very simplified version of the current project I am working up. The current project is for Locations vs All Patterns (just table name for store transactions). Below are screenshots of requested. For the purpose of this example, Location = NBA_Player. Please let me know if this works. 

[Sergii24]

So you want to say that using any column from "Location" table the data in "All Patterns" is not filtered correctly?

In such case, firstly, create a new table that contains a single column from "All Patterns", then apply a filter on "Location". Is your tavble filtered correctly? If yes, then there might be an issue with your "Team_Count" measure. If not, then there is an issue within a relationship, you'll need to investigate more in details what is going on (check data types, list of values, presence of leading zeros, trim values etc.) 

I hope it will help!