count rows/Sum rows without aggregation

[Maz_0102]

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 

[Anonymous]

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

[sergej_og]

Hey @Maz_0102 ,
can you pls provide your target result?
I´m not sure to get it right.

Regards

[Maz_0102]

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