Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Advice Please Variation Visual

I need some advice.   I have a dataset similar to this;   Staff_Name Start_date Leave_date Person A 02/01/2020 12/01/2020 Person B 03/01/2020 12/01/2020 Person C 12/12/2019 ...
General Comment
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-yingjl ,

 

I am getting an error with this column.

 

Starter =
CALCULATE ( COUNTROWS ( employee_profiles ), employee_profiles[leaver_notifications.leave_date] = BLANK () )
 
The error is;
 
A circular dependency was detected: employee_profiles[Column], employee_profiles[Leaver], employee_profiles[Column].
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi Anonymous ,

In my sample file, the only the 'Leave?' is a calculated column, ohters like starters is a measure. You can try my sample file to create a measure not a calculated column to get it. Not recommend to create muti calculated columns which refer all columns in a table.

Please refer these two articles:

  1. Avoiding-circular-dependency-errors-in-dax 
  2. Calculated Columns vs Measures in DAX 

 

Best Regards,
Yingjie Li

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