Forum Discussion
lmiguellf
1 year agoFrequent Visitor
ALL function disabled when applying date slicer
Hi, I'm new to power bi, and i'm trying to calculate the OEE in a company. I'm supposed to calculate the availability for every equipment, then the performance and quality for every component p...
johnt75
1 year agoSuper User
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.
lmiguellf
1 year agoFrequent Visitor
Yes, although the problem with the filters persists, since i still can't apply then to the combined table since i get duplicated values.