I have a measure that counts the number of employees. The number of employees is more than a thousand employees. I have to click on the measure to access the measure tools and click the comma icon because the number is greater than a thousand. I have another measure that counts the number of departments with some special characters. I want to concatenate the two measures, but when I do, I lose the comma from the first measure. Here is the Dax of which I have:
Number of Employees and Departments = CONCATENATE(CONCATENATE(CONCATENATE([Number of Employees], " ("), [Number of Departments]), IF([Number of Departments] = 1, " dept.)", " depts.)"))
