Forum Discussion

Kbal's avatar
Kbal
Regular Visitor
7 years ago
Solved

ALLEXCEPT + USERELATIONSHIP

Hi, I have the following model : In the table KM_Final, I have a circular dependancy between 2 calculated columns : -  PFS2_Count = var records = CALCULATE(COUNT('treatments'[id]) ;...
Need Help
  • Kbal's avatar
    Kbal
    7 years ago

    HI v-piga-msft

     

    Thank you for your reply, I need a column instead of measure to reuse it in another column.

    But i have found my error : I was wrongly using ALLEXCEPT to remove filter context from the specified column.

    The solution in my case is to use ALL(KM_Final[PFS2_Running]), and the circular dependency dissapears :

     

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Kbal,

 

For your scenario, I'm afraid that if you add : ALLEXCEPT(KM_Final ; KM_Final[PFS2_Running]) to the first column PFS2_Count, it will still have the error.

 

For your case, I will suggest create PFS2_Running as a measure that should avoid the circular dependency.

 

Best  Regards,

Cherry

  • Kbal's avatar
    Kbal
    Regular Visitor
    7 years ago

    HI v-piga-msft

     

    Thank you for your reply, I need a column instead of measure to reuse it in another column.

    But i have found my error : I was wrongly using ALLEXCEPT to remove filter context from the specified column.

    The solution in my case is to use ALL(KM_Final[PFS2_Running]), and the circular dependency dissapears :