Forum Discussion

user900's avatar
user900
Icon for Helper II rankHelper II
4 years ago
Solved

Measure help including circular dependency errors

Hi, Hoping someone can help me create some measures. I'm new to BI and I'm getting circular dependency errors and not sure how to resolve.   I need to show how much time each user is spending in an...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi user900 ,

     

    Please try:

    Total Usage = CALCULATE(SUM('Table'[Usage Time]),ALLEXCEPT('Table','Table'[User],'Table'[Date].[Year],'Table'[Date].[Month]))
    Status = 
var _2022Goal = 20
return IF(CALCULATE(SUM('Table'[Usage Time]),ALLEXCEPT('Table','Table'[User]))>=_2022Goal,"Complete","Not Complete")

    Output:

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi user900 ,

 

Please try:

Total Usage = CALCULATE(SUM('Table'[Usage Time]),ALLEXCEPT('Table','Table'[User],'Table'[Date].[Year],'Table'[Date].[Month]))
Status = 
var _2022Goal = 20
return IF(CALCULATE(SUM('Table'[Usage Time]),ALLEXCEPT('Table','Table'[User]))>=_2022Goal,"Complete","Not Complete")

Output:

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

user900's avatar
user900
Icon for Helper II rankHelper II
4 years ago

This worked perfectly. Thank you.