Forum Discussion

Berl21's avatar
Berl21
Helper III
3 years ago
Solved

Circular dependency calculated table

Hi,

 

I created a calculated table with the following command:

 

Leads Amount PY =
CALCULATETABLE(
SUMMARIZE(
    Leads_Table,
     Leads_Table[ZH_Account__c],
     Leads_Table[Lead_Creation_Date],
    "Count of Leads PY",
    [Count Leads]
),
YEAR ( Datetable[Date]) = YEAR ( TODAY () ) -1
)

 

When I try to add it in the model, I get the following mistake:

 

I am connecting Lead_Creation_Date to the column "Date" in my calendar table. There are no other link between the two tables. What are the typical scenarios I should double check?

 

Thanks,

 

Pauline.

Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, Berl21 ;

    You could add a dax ALLNOBLANKROW() such as :

    Leads Amount PY =
CALCULATETABLE (
    SUMMARIZE (
        ALLNOBLANKROW ( Leads_Table ),
        Leads_Table[ZH_Account__c],
        Leads_Table[Lead_Creation_Date],
        "Count of Leads PY", [Count Leads]
    ),
    YEAR ( Datetable[Date] )
        = YEAR ( TODAY () ) - 1
)

    You could refer this video.

    Avoiding circular dependency errors in DAX - YouTube
    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    Hi, Berl21 ;

    You could add a dax ALLNOBLANKROW() such as :

    Leads Amount PY =
CALCULATETABLE (
    SUMMARIZE (
        ALLNOBLANKROW ( Leads_Table ),
        Leads_Table[ZH_Account__c],
        Leads_Table[Lead_Creation_Date],
        "Count of Leads PY", [Count Leads]
    ),
    YEAR ( Datetable[Date] )
        = YEAR ( TODAY () ) - 1
)

    You could refer this video.

    Avoiding circular dependency errors in DAX - YouTube
    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    Hi, Berl21 ;

    Is your problem solved?  If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.