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.
Hi,
Share your PBI file with the visual already built in there.
Hi again and apologies for the delay. Below there is my folder link with the pbix and source folder.
https://1drv.ms/f/s!AjU3fZfEMvkyhZxZadtXP2a_-BmS4g
As stated before I would like to undersatnd why the filter is not propagated to the visual, as i would expect. I am asking for a logic explanation in order to undersatnd this basic pricnciple (ex is it due because is a MANY to 1 and the filter is in the 1 side?). Consider also that I may encounter situations where I have more than one query linked and I would like to create correct visual combining different fields coming from different query. Is the best behaviour Merging the queries incorporating the field and filtering on each query? (in few words propagating the field across different query linked together?)
Thanks in advance
Luca
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.
