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 ...
I believe this Calculated Column should get you what you need:
ColorCount = CALCULATE( COUNTA([Color]), ALLEXCEPT( 'Product', 'Product'[Color] ))Product IDColorCountColorCount
| 123 | Red | 1 | 4 |
| 124 | Blue | 1 | 3 |
| 125 | Blue | 1 | 3 |
| 126 | Red | 1 | 4 |
| 127 | Yellow | 1 | 2 |
| 128 | Red | 1 | 4 |
| 129 | Yellow | 1 | 2 |
| 130 | Red | 1 | 4 |
| 131 | Blue | 1 | 3 |
Regards,
I need to show the ProductID without the color
Once you have your Calculated Column in the data model, you can create any Visual that you want.
For a simple Table Visual, simply use your ProductID and ColorCount columns. You don't need to show the Color field in your visual.
Dang... my actual dataset is much more complex and I am not able to do that... the ProductID and Color was too simple.
