Forum Discussion
Loops,Fan Traps and chasm Traps
Hello All,
I was just wondering if anyone has faced Loops, Fan Traps or chasm Traps like in we have in "SAP Business objects "modeling. Do we face such kind of issues in Power BI Modelling? If we encounter a scenario, how do we resolve it?
Anonymous ,
Thanks,
Aditya
3 Replies
- AnonymousNot applicable
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
- AnonymousNot applicable
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
- AnonymousNot applicable
HI Anonymous ,
In my opinion, I think bridge table should suitable for your requirement to achieve fan traps and chasm traps:
Regards,
Xiaoxin Sheng