Add Column with COUNTROWS DAX Formula

[united2win]

Hi,

I have the following data set in table - Sales and Bookings:

Account + Product

00001234-Additional EU Returns

00001234-Additional EU Returns

00001234-Additional EU Returns

00001235-Additional VAT

00001235-Additional VAT

I want to add a column to calculate # of times that text.value appears on each row. The desired outcome would be:

Account + Product                                     Count of Account + Product

00001234-Additional EU Returns                                  3

00001234-Additional EU Returns                                  3

00001234-Additional EU Returns                                  3

00001235-Additional VAT                                             2

00001235-Additional VAT                                             2

From there, I will extend the use of those values for various calculations. Does anyone know the DAX Formula that I need to use in order to proceed?

Thank you. 

Rookie Power BI User.

[ChrisMendoza · Accepted solution]

@united2win -

Column = 
CALCULATE(
    COUNTROWS(TableName),
    ALLEXCEPT(TableName,TableName[Account + Product])
)