Forum Discussion

WLFRD's avatar
WLFRD
Icon for Helper III rankHelper III
4 years ago

Count per group

Hello,   I think the solution for my question is simple but for some reason I cannot find the answer to my question.   So, I have this table:   Unit B100 B200 B100  C100 C100 ...
Need Help
mh2587's avatar
mh2587
Icon for Super User rankSuper User
4 years ago

count = count(table[unit])

  • WLFRD's avatar
    WLFRD
    Icon for Helper III rankHelper III
    4 years ago

    When I use this expression, it counts the total amount of units. I would like to have a total count per unit. In Power BI you can click on 'count' at values ​​and then the total will be shown. I just need a column for a calculation and then I need a column with the totals per unit.
    Does this count have to be filtered?