Forum Discussion
ALL function disabled when applying date slicer
I suspect that the problem is because of the bi-directional relationships. As it is currently, a filter on any table will affect every other table. Unless you have very good reason to use bi-directional relationships you should always use single direction relationships with the one-side filtering the many-side.
The problem is that i want my filters to be filtering both tables, dados and paragens. Without the bi-directionality i would need to add the columns that i want to use in the slicers in the dim table dados_paragens. However i cannot do this because when i add them, the key column Nº Ordem that i was using to link the tables returns duplicate values and no longer works to link. Also if i create a new key column with the combinations of the slicer columns i don't achieve a unique column as well, so i have no key to link the tables.
You could potentially combine the 2 dimension tables, e.g.
Combined Table = DISTINCT ( UNION ( DISTINCT ( Dados_Paragens ), DISTINCT ( Dados_Teoricos ) ) )and then link this single table to the fact tables, removing the other relationships. Then the relationships from the new combined table could be single direction.
Yes, although the problem with the filters persists, since i still can't apply then to the combined table since i get duplicated values.