Forum Discussion

Maz_0102's avatar
Maz_0102
Helper I
2 years ago

count rows/Sum rows without aggregation

Hello fellow power bi wizards

 

Number of units = 

I'm trying to sum of units for each building you can see first three rows are the same unique ID so it aggregates the sum for all three row

I just want the sum per building

 

also I want to do this filter based on another column which is a category column e.g. red, amber, green, blue

 

so I want to count the number of units filters by category without aggregating for every row 

 

can someone please advise 

 

 

 

Need Help
Show and Tell
Tips and Tricks

3 Replies

    • Maz_0102's avatar
      Maz_0102
      Helper I
      2 years ago

      The first three rows which is the same unique ID is 301

       

      If I did sum it sum all three rows but I just need to return 301 and the same for every other row

       

      I also need to this sum based on a filter of another category column as well

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Maz_0102 ,

    In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu