Forum Discussion
Loops,Fan Traps and chasm Traps
HI Anonymous ,
Do you means circular dependency ? If this is a case, current power bi not allow you to create circular dependency fields. When power bi recognize this type of calculation, it will display error message and skip calculate on these parts.
Avoiding circular dependency errors in DAX
Regards,
Xiaoxin Sheng
No not circular dependency.
circular dependency: A Dependency when one measure is interdependent on each other.
Chasm Traps : Def : https://documentation.sisense.com/latest/managing-data/working-with-data/chasm-fan-traps.htm#gsc.tab=0
I am talking in a scenario where the join of 3 tables in modeling results in more records, as we have in SAP Universe.
Regards,
Aditya
HI Anonymous ,
In my opinion, I think bridge table should suitable for your requirement to achieve fan traps and chasm traps:
Regards,
Xiaoxin Sheng