Hi @Dharma - Rewent through your problem. The Total count will not match with the table rows individual count. This is because of change in the evaluation context.
While counting values for individual row, Evaluation context is the “New Role Entry Date” and corresponding “Join Date” and based on this the output is calculated while during Total there is no “New Role Entry Date” or “Joining Date” context and Power BI takes the maximum and minimum values available and calculate based on that.
This is also clearly explained in Blog post by Greg and shared by EDNA team Fix Incorrect Totals
Hope the explanation is helpful.
Thanks
Ankit J