Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I need help on resolving circular dependency error on my formula:
Sales Level =
SWITCH(TRUE(),
'Sales'[Sales by Product]>=1000000,"Level1",
'Sales'[Sales by Product]<=999999 && 'Sales'[Sales by Product]>=500000,"Level2",
'Sales'[Sales by Product]<=499999 && 'Sales'[Sales by Product]>=100000,"Level3",
"Level4"
)
The formula for "Sales by Product" which was used in column above:
Sales by Product =
SUMX(
KEEPFILTERS(VALUES('Sales'[ProductID])),
CALCULATE(SUM('Sales'[Actual]))
)
Hoping for any assistance.
Solved! Go to Solution.
Hi @summer18 ,
Is Sales by Product a calculated column? If so try this instead:
Sales by Product =
CALCULATE (
SUM ( 'Sales'[Actual] ),
ALLEXCEPT( 'Sales'[ProductID] )
)
Have a read of
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Which explains why you get circular dependency.
Hi,
I need help on resolving circular dependency error on my formula:
Below is the calculated column:
Hi @summer18
Please try this
Sales Level =
SWITCH(TRUE(),
'Sales'[Sales by Product]>=100000,"Level3",
'Sales'[Sales by Product]>=500000,"Level2",
'Sales'[Sales by Product]>=1000000,"Level1",
"Level4"
)
If not work, please share sample data or pbix file.
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos
Hi @PijushRoy , it did not work. I think I have to remove the circular dependency on ProductID but I don't know how.
Hi @summer18 ,
Is Sales by Product a calculated column? If so try this instead:
Sales by Product =
CALCULATE (
SUM ( 'Sales'[Actual] ),
ALLEXCEPT( 'Sales'[ProductID] )
)
Have a read of
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Which explains why you get circular dependency.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |