Forum Discussion
Como crear una relacion 1:1 entre dos tablas en Excel 2016
Data model in Excel doesn't support bi-directional relationships (many-to-many and one-to-one). Moreover, such kind of relationship is not recommended to use in general.
Alternatively you may create explicit measure like
=CALCULATE(myAggregation, CROSSFILTER( Analysis[Id] ,Operations[Id], Both ))
Even better is to add bridge table with IDs only, hide Id both in Analysis and Operations and use it only from Bridge
Data model in Excel doesn't support bi-directional relationships (many-to-many and one-to-one). Moreover, such kind of relationship is not recommended to use in general.
Alternatively you may create explicit measure like
=CALCULATE(myAggregation, CROSSFILTER( Analysis[Id] ,Operations[Id], Both ))
Even better is to add bridge table with IDs only, hide Id both in Analysis and Operations and use it only from Bridge