Forum Discussion
ALL function disabled when applying date slicer
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.