Dynamic Filters are not working when created as new column using "Add as a New Query".

[ved_007]

Hi Team,

I have two tables and I was not able to join both tables because both tables doesn't have unique values. So as a workaround I have created a new column using 'edit queries'-> selected the joinable col' -> 'Add as New Query' -> 'To Table' -> 'OK' -> 'Remove Duplicates' -> 'Remove Nulls'. New column "site_name_latest" which I later on used as a join key to join with both tables using manage relationship.
Similarly I have created another col as "team_name". Now when i am using these two cols as filters and when I am selecting one site it is not reflecting in the team filter, but all values in team. It is not acting as a dynamic filter.
Please help as its urgent requirement.

[GilbertQ]

Hi @ved_007

Do you have some sample data?

It would possibly appear that their the relationship is not in the right direction, or possibly there is something missing with the data?

[ved_007]

Hi @GilbertQ

I have attached only the screenshot of the data as it is production data.
Site and Team names were added using Add as a New Query. But when these used as slicers, site is not showing the relevant team in it.
Thanks

[GilbertQ]

Hi @ved_007

It would appear that in your table shown there are duplicates because you have got a date column in there also.

Would it be possible to only have the team names and the site name?

[ved_007]

Thanks @GilbertQ for quick response.

PFA screens for your consideration.

I have created date as "Add as a new query" column also and using it as slicer in report. So when I use site,team in my original table and using them in report it shows teams for a site but not when it is created as new cols and even though I have done remove duplicates for each newly created cols as a step. I think it should come from single table which can't be possible for my case as these cols are used as a a join key to join two tables.

After doing above steps site, team are coming from different tables so the dynamic filters are not working anymore.
If you can share a working report(some sample) using my scenario It would be good. Report should come from my side for your debugging, but I am sorry it was made using prod. data. 

Thanks