Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Very simple COUNT issue

I have this table and i want to simply have the number of each iitem based on the column
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

    To calculate the number of item per ProjectId, you could place [ProjectId] column into table visual together with below measure.

    Count Measure=Count(Table[ProjectId])

    Alternatively, to get the number of item per ProjectId in a calculated column, please refer to this formula.

    Count Column =
CALCULATE ( COUNT ( Table[ProjectId] ), ALLEXCEPT ( Table, Table[ProjectId] ) )


    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

 

To calculate the number of item per ProjectId, you could place [ProjectId] column into table visual together with below measure.

Count Measure=Count(Table[ProjectId])

Alternatively, to get the number of item per ProjectId in a calculated column, please refer to this formula.

Count Column =
CALCULATE ( COUNT ( Table[ProjectId] ), ALLEXCEPT ( Table, Table[ProjectId] ) )


Best regards,

Yuliana Gu