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_Creati...
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.

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.