Blog Post

Power BI Community Blog

1 MIN READ

Custom Calculation Issue with Circular Dependency Fields

Microsoft Employee

6 years ago

Issue: Custom calculations with circular dependency fields were not updating while performing YTD and IF DAX functions. Requirement: Get updated value in the 'Target Value' column for the GL_ACCT 3...

Updated 6 years ago

Version 3.0

Microsoft Employee

Joined March 11, 2019

View Profile

Power BI Community Blog

On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.

PLHARNA

Frequent Visitor

6 years ago

Hi,

In my opinion you have "String" value in GL Account field. Please change the formula to:

arget Value = var bc = SUM(data[Amount])

var ab = SUM(data[Amount]) + TOTALYTD(

SUM(data[CM_PL]),

'Calendar Table'[Date]

) Return IF(SUM(data[GL_ACCT])="3100000",ab,bc)

I can be wrong, let me know if this helps.

Best regards