Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

COUNT in a table per row

Hello everyone! I recently started a project where I have the following table loaded in DirectQuery mode: Then I need to add a column in which I make the division of "SalesSale Count" by ...
  • amitchandak's avatar
    amitchandak
    4 years ago

    Syndicate_Admin , A new column = DISTINCTCOUNT(Table[DATE])

    will give grand total

    in measure DISTINCTCOUNT(Table[DATE]) will give row value

     

    and calculate( DISTINCTCOUNT(Table[DATE]), allselected(Table )) , will give you grand total

     

    what final calculation you need

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Syndicate_Admin , A new column = DISTINCTCOUNT(Table[DATE])

will give grand total

in measure DISTINCTCOUNT(Table[DATE]) will give row value

 

and calculate( DISTINCTCOUNT(Table[DATE]), allselected(Table )) , will give you grand total

 

what final calculation you need

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

I need the value per row, so I tried the DISTINCTCOUNT(Table[DATE]) measure and it worked.

Thank you very much, @amitchandak !