Forum Discussion
PowerBIUser349
Helper I
Helper ICount 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 ...
rsbin
Community Champion
Community ChampionI 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,
PowerBIUser349Helper I
Helper II need to show the ProductID without the color
- rsbin
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.
- PowerBIUser349
Dang... my actual dataset is much more complex and I am not able to do that... the ProductID and Color was too simple.
- PowerBIUser349
This is a better sample dataset... I only added two rows, but shows the problem I am facing with the dax formula you shared above.
Product ID Color Count 123 Red 1 124 Blue 1 125 Blue 1 126 Red 1 127 Yellow 1 128 Red 1 129 Yellow 1 130 Red 1 131 Blue 1 123 Red 1 124 Blue 1 - rsbin
Are you now saying your Table includes duplicates?
Product ID Color Count 123 Red 1 124 Blue 1 123 Red 1 124 Blue 1 Do you want these duplicates counted or not?