Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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!
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
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
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)
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |