Forum Discussion

BiJoe's avatar
BiJoe
Helper II
2 years ago
Solved

Add column with duplicate value counts

I have a denormalized employee dimension table, and employee fact table with key columns.   Some of the employees have same roles in multiple departments, and I want to add a column to the table, s...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi BiJoe ,

Please try:

Count = COUNTROWS(FILTER(ALL('dim_employee'),'dim_employee'[Name]=RELATED('dim_employee'[Name])))



Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum