Forum Discussion
Solved
Simple filter not reflected
Dear gurus, I am fairly new to PBI. I have this "issue" that simply I cannot absorb, and I would like to have a logic anwser. I have two simple table "Clients" and Country having key the CountryCo...
Hi,
There is nothing wrong in what you have done. All i can suggest is that instead of dragging the Client Name from the Clients Table to the value section of the visual, write this measure
=COUNTA(Clients[ClientName])
Now, as regards your question, the reason you see Blank in the visual is that NZ is not listed in your Countries Table. Since the Countries Table is the master table, it should contint a list of all countries (even those that are not in your Cleints list). The moment you do that, Blanks will be replace with New Zealand.
HiRoss73312,
Thanks for your email. My doubt is not on how to achieve the goal by hiding the blank. Is why this is happening. The country table contains just US NZ UK AUS and also the client table contains only those values. Countrycode is the key for the relationship.And I have filtered excluding US and UK.
I would have expect to do not see the blanks after the filter action on the Country table.
As you said somehow the client contains those values anyway but why? Is due to the fact that is a one to many? The or is the visual that is wrong? And why the Data menu still show those values for clients even if they are related?
Thanks
Luca
Thanks for your email. My doubt is not on how to achieve the goal by hiding the blank. Is why this is happening. The country table contains just US NZ UK AUS and also the client table contains only those values. Countrycode is the key for the relationship.And I have filtered excluding US and UK.
I would have expect to do not see the blanks after the filter action on the Country table.
As you said somehow the client contains those values anyway but why? Is due to the fact that is a one to many? The or is the visual that is wrong? And why the Data menu still show those values for clients even if they are related?
Thanks
Luca
Without seeing the data its hard to know specifically, but typically it indicates that however your table structure is set up, those records are not achieving a match.