Filter Table

Hi, I'm starting on Power BI, could you help me with the following question.

I have a sales table, each sale that the seller makes is consolidated in that table.

I would like to create a table with the region and product filters, but when I filter continue showing all salespeople, and those who did not sell in that filter that is blank but remains in the table.

When I make the filters it filters the salespeople and lets only those who made the sales appear.

The image below shows the result I have and the expected.

Thanks in advance for your help.

TABLE SALES
NAME	REGION	PRODUCT	NUMBER SALES
ANDY	R1	P1	2
JONNY	R2	P2	3
RICK	R2	P1	2
ANDY	R3	P1	1
ANDY	R1	P2	4
RICK	R1	P2	2
MICK	R2	P3	1
MICK	R2	P3	5
MICK	R2	P2	2
JONNY	R2	P2	1
PATRICK	R4	P2	2

Need Help

amitchandak
5 years ago
tarocha , for that you need to create star schema with name, region, and product table. Name is a must in this case.

Please find the file attached after signature

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
Test(3).pbix2 MB
Greg_Deckler
5 years ago
tarocha - I created a table like this:

Names = DISTINCT('Table'[NAME])

I related this table to the other table and I replaced NAME column in this table for the NAME column in the original table for Rows. Once I did this, I could click on the dropdown arrow for NAME in Rows and select "Show items with no data".

See attached PBIX file below sig.
Test (1).pbix2 MB