Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a power BI dashboard for employee attrition, where I have created a measure that calculates attrition percentage and a custom column that is Date difference of leaving and Date of Joining (Tenure). This measure show correct output when I use it with my date column, but when I use my Tenure column it is not giving me correct output. The subtotal it shows is correct but when I manually add up the rows it does not sum up to the subtotal.
Hi @Suchitkotak ,
This sounds a use with relationship inbetween the tables . I think there is a relationship between one date column and calender table and the tenture does not have any relationship .
In this senario you need to create a inactive relationship with tenture date column .
Please refer to this link :-
https://learn.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
Proud to be a Super User!
Thank you for your response @pratyashasamal , actually Tenure is a custom created column which consists of bucket values like "1-3 years", "3-5 years" etc depending on how many years employee is in the firm. DAX code is like this:
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |