Forum Discussion
Maz_0102
2 years agoHelper I
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 ju...
sergej_og
2 years agoSuper User
Hey Maz_0102 ,
can you pls provide your target result?
I´m not sure to get it right.
Regards
- Maz_01022 years agoHelper I
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