Forum Discussion

united2win's avatar
united2win
Helper III
7 years ago
Solved

Add Column with COUNTROWS DAX Formula

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-Ad...
Need Help
Show and Tell
Tips and Tricks
  • ChrisMendoza's avatar
    ChrisMendoza
    7 years ago

    united2win -

    Column = 
CALCULATE(
    COUNTROWS(TableName),
    ALLEXCEPT(TableName,TableName[Account + Product])
)
ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
7 years ago

united2win -

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