Forum Discussion
Simple filter not reflected
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.
Based on what i can quickly see. Does your country table have every possible country code that might be contained in your Client data? Based on the bar chart, the (Blank) indicates to me that all of those clients are unable to be linked to your country table some how.
If that was intentional, what you need to do is set up a page level filter that hides any of those blanks.
- 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
LucaWithout 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.
