Forum Discussion
Count distinct values in hierarchy
maryJ Did you tried debugging by returning each count separately (Reporter,RM,Emloyee) so that you can easily figure it out where the duplicate counts are coming from.
Also, as per test data provided - I didn't check whether Reporter or RM is present in Employee (to exclude counting them again) but if that is not the case in your actual data then you need add those filter criteria to Employee Count as well.
Community ChampionmaryJ Did you tried debugging by returning each count separately (Reporter,RM,Emloyee) so that you can easily figure it out where the duplicate counts are coming from.
Also, as per test data provided - I didn't check whether Reporter or RM is present in Employee (to exclude counting them again) but if that is not the case in your actual data then you need add those filter criteria to Employee Count as well.
PattemManohar
ohhh, you was absolutely right! I added check in my Dax in order to verify if RM is present in Employee column and it showed me a correct number . Finally!! :smileyvery-happy: The problem was in hierarchy levels, so it appeared that RM also could be an employee...
Problem solved!
Thank you very much!
I really appreciate your quick help!
Have a great day!:smileyhappy:
- PattemManohar
maryJ That's cool :smileyhappy: