Forum Discussion
Count by Group
Hey Everyone, I know this is going to be simple for someone experienced in PBI. I am still getting use to specific functions and could use some help. Here is a sample dataset: Product ID Color ...
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.