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:
data_operador1_0-1642079910409.png

Then I need to add a column in which I make the division of "SalesSale Count" by a DISTINCTCOUNT(Table[DATE]), but I think it cannot, so I have created my own column, called "Manual SalesSaleTh Count" using the COUNT(Table[SalesDate]) function the column created is as follows: (Option "Unsummarised" in the values of the table)

data_operador1_1-1642080467887.png

Can you think of any method or way to be able to make the division?
Thank you very much in advance.
  • 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

2 Replies

  • 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 !