How to group values

Hi friend11_6,

Thank you for reaching out to the Microsoft Fabric Forum Community.

To group all variations of the same employee under a single classification, you should group by Employee ID only, not by the full Employee string.

Try creating the table with the following DAX.

SummaryTable =
VAR BaseTable = 'EmployeeData'
RETURN
ADDCOLUMNS (BaseTable,
"Group Label",SWITCH (TRUE(),
BaseTable[Record 2 - Record 1] = 0, "Reconciled",
ISBLANK(BaseTable[per Record1]), "Not in Record 1",
ISBLANK(BaseTable[per Record2]), "Not in Record 2",
"Other"))

Thanks & Regards,
Prasanna Kumar