COUNT in a table per row

[Syndicate_Admin]

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 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)

Can you think of any method or way to be able to make the division?

Thank you very much in advance.

[amitchandak · Accepted solution]

@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]

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

Thank you very much, @amitchandak !