Forum Discussion

PowerBIUser349's avatar
PowerBIUser349
Helper I
3 years ago

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 ...
Need Help
rsbin's avatar
rsbin
Community Champion
3 years ago

PowerBIUser349 ,

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,

rsbin's avatar
rsbin
Community Champion
3 years ago

PowerBIUser349 ,

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,

 

  • PowerBIUser349's avatar
    PowerBIUser349
    Helper I
    3 years ago

    I am still trying to figure it out. I attached a pbix file to the orignial post. Thank you for your help. 

  • rsbin's avatar
    rsbin
    Community Champion
    3 years ago

    PowerBIUser349 ,

    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,

  • PowerBIUser349's avatar
    PowerBIUser349
    Helper I
    3 years ago

    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.