Forum Discussion
Count by Group
Good question. And sorry for not explaining better. I still need it to return this:
| Product ID | Group Count |
| 123 | 4 |
| 124 | 3 |
| 125 | 3 |
| 126 | 4 |
| 127 | 2 |
| 128 | 4 |
| 129 | 2 |
| 130 | 4 |
| 131 | 3 |
Which means it would be a distinct count of Product ID, but showing the subtotal count for each color.
So, I think you are looking for a new Calculated Table.
Unfortunately, I have to sign off, but will try to look at it later this evening or tomorrow for you.
Kind Regards,
Do not want to leave you hanging if this issue is still unresolved. Would like to try to clean this up if need be. I think the first step is to get this calculated column from my original response working for you.
ColorCount = CALCULATE( COUNTA([Color]), ALLEXCEPT( 'Product', 'Product'[Color] ))If possible, please attach a sample pbix file and I can try to work with that.
Regards,
I am still trying to figure it out. I attached a pbix file to the orignial post. Thank you for your help.
Nevermind... I don't have the option to attach files. See this link: https://drive.google.com/file/d/1kDUwCJccvUTnm-czvExzVi9t8YUXWyo4/view?usp=sharing
Think I got it straightened out now. My original reply was to create a Calculated Column. You inadvertently created a Measure. That is why it was not working the way I intended.
Please review the attached with my corrections. I hope this now resolves the issue.
Best Regards,
I see. Unfortunately this doesn't work for my actual data... it works for this scenario, but my dataset is much more granular and this formula is counting every row in the table.