Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ,

v-juanli-msft 

 

Thanks,

Aditya

3 Replies

  • Anonymous's avatar
    Anonymous
    Not 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

      • Anonymous's avatar
        Anonymous
        Not 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