Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the data model as shown in the image below.
I have two columns called A and B in my fact table, and a column named "employed more than 3 months" in my employee dimension table. (please ignore the other columns)
What I need is to have a column as following in my fact table:
C= A- B
and then I need to have a column which produce the result as follow:
result= IF [C <= 0 AND [employyed more than 3 months] = 'True'
THEN [C]
ELSE 0
END
I tried to create a calculated column with CALCULATE() function, but I receive a circular dependency error.
can someone help me create this?
Solved! Go to Solution.
Hi @Anonymous
I would suggest you create only one column like below.For further,please refer to below article.
https://www.sqlbi.com/articles/understanding-circular-dependencies/
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Column = IF ( CALCULATE ( SUM ( [A] ) - SUM ( [B] ) ) < 0 && RELATED ( Dim_EmployeeData[employyed more than 3 months] ) = "True", CALCULATE ( SUM ( [A] ) - SUM ( [B] ) ), 0 )
Regards,
Hi @Anonymous
I would suggest you create only one column like below.For further,please refer to below article.
https://www.sqlbi.com/articles/understanding-circular-dependencies/
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/
Column = IF ( CALCULATE ( SUM ( [A] ) - SUM ( [B] ) ) < 0 && RELATED ( Dim_EmployeeData[employyed more than 3 months] ) = "True", CALCULATE ( SUM ( [A] ) - SUM ( [B] ) ), 0 )
Regards,
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |