Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a formula but getting "circular dependency error" that points to Prior Month budget but my formula is for Sales Actual.
Formula with error:
IF('Sales'[Department]="IT",0,'Sales'[YoY])
Here are the formulas related to my measure above:
YoY formula = (SUM(Actual)-[PY Actual]) / [PY Actual])
How can I fix the error?
Solved! Go to Solution.
I'm assuming that the formula you state is for a calculated column?
If so have a read of Avoiding circular dependency errors in DAX - SQLBI.
In the expression for the calculated column you want to wrap your [YoY] measure inside a calculate with an ALLEXCEPT to prevent it from adding everthing into the filter context.
I'm assuming that the formula you state is for a calculated column?
If so have a read of Avoiding circular dependency errors in DAX - SQLBI.
In the expression for the calculated column you want to wrap your [YoY] measure inside a calculate with an ALLEXCEPT to prevent it from adding everthing into the filter context.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
6 |