Add Column with COUNTROWS DAX Formula

Question

Hi,&nbsp;I have the following data set in table - Sales and Bookings:&nbsp;Account + Product00001234-Additional EU Returns00001234-Additional EU Returns00001234-Additional EU Returns00001235-Additional VAT00001235-Additional VAT&nbsp;I want to add a column to calculate # of times that text.value appears on each row. The desired outcome would be:Account + Product&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Count of Account + Product00001234-Additional EU Returns&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300001234-Additional EU Returns&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300001234-Additional EU Returns&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300001235-Additional VAT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200001235-Additional VAT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp;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?&nbsp;Thank you.&nbsp;&nbsp;Rookie Power BI User.&nbsp;

chrismendoza · Accepted Answer

united2win&nbsp;-Column = 
CALCULATE(
    COUNTROWS(TableName),
    ALLEXCEPT(TableName,TableName[Account + Product])
)

Forum Discussion

Add Column with COUNTROWS DAX Formula

1 Reply

Related content

If formula

formula

DAX Formula Help

COUNTROWS

Multiple Filters (COUNTROWS)