Forum Discussion
Solved
Group By Name Then Add Column With Count Of Each Group
Hi, I'm trying to group together names and then get a count of each group, and add the count of the records group to itself (for every row). There's an example below. I do specifically need it t...
Create a new column with:
Count = CALCULATE(COUNT('Table'[[Name]]]), ALLEXCEPT('Table', 'Table'[[Name]]]))
No idea why I struggled with this so much, many thanks!
Just as a note for anyone who has the same issue and is having "one of those days". Make sure to check that your visuals aren't "summarizing" your counts. Was so convinced I was doing something wrong before I never checked the obvious.