calculate total DAX issue

Hi baneworth ,

My steps are to go to Power Query Editor first. Select the [SubLoc] column and split the column.

Select these four columns and unpivot the columns.

Then new two measures:

SubLoc = CONCATENATEX(FILTER('Table','Table'[Serial Number]=MAX('Table'[Serial Number])&&'Table'[ID]=MAX('Table'[ID])&&'Table'[Loc]=MAX('Table'[Loc])),'Table'[Value],",")

Count = COUNT('Table'[Value])

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data