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 ...
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.