cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Anonymous
Not applicable

Issue with Circular Dependency! Need Help!

Hello Team,

 

I am trying to create a couple of measures and running into a circular dependency, the measures are as below:

Remaining = Start of Day - (sum of all tickets closed that day)

Start of Day = Added + Previous Day Remaining

Added is the new tickets received per day.

I am using a Direct Query mode as per the requirement.

Please let me know of a way to mitigate this issue!

 

Thanks in advance!

2 REPLIES 2
amitchandak
Super User
Super User

Make sure you have a date table in your database, Mark that as the date table in Power BI. Then these formulae can be used for today and yesterday

 

Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Day))
Today  = CALCULATE(SUM(Sales[Sales Amount]),filter('Date','Date'[Date]=Today())
// Today  = CALCULATE(SUM(Sales[Sales Amount]),today())

Please refer my blog on the direct query to check more on the date table

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-1-Time-Intell...

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @

Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

Anonymous
Not applicable

Hi @amitchandak ,

 

Thanks for your response, but i am unsure how this can be applied in my scenario. As mentioned, my Start of Day measure and Remaining measure are interdependent and causing a circular dependency

 

Start of Day = Added Today + Previous Day Remaining 

Remaining = Start of Day(various other metrics)

 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors