Hi Community, Tried to count how many products the employee worked, sounds easy at the beggining but I cant count the second column. Tried usuingDISTINCTCOUNTNOBLANK, but I can´t tell PBI to merge shift1+shift2 and give me a single result. Also tried some suggestions with sumx but the data is a string, and I got errors. Thanks in advance for any help... Desire resultsProductShift1Shift2NameProductsWorkedaWadeBrianWade2bDaveRobertoDave3cSethRamonSeth4dBrian Brian3eRobertoRileyRoberto2fRamonGilbertRamon3gJorgeGilbertJorge1h DanGilbert5iBrianWadeRiley1jRobertoDaveDan1kRamonSeth lRamonBrian m Dave nGilbertRamon oGilbertSeth pGilbertSeth

Hi Aucesar You can refer to the following measure 1.Create a table to diaplay the user 2.Then create a measure ProductionBatchWorked = var a=SUMMARIZE(ALLSELECTED('Table'),[ProductionBatch],[Shift1]) var b=SUMMARIZE(ALLSELECTED('Table'),[ProductionBatch],[Shift2]) var c=SUMMARIZE(UNION(a,b),'Table'[Shift1],"Distinct",DISTINCTCOUNTNOBLANK('Table'[ProductionBatch])) return MAXX(FILTER(c,[Shift1] in VALUES('Table 2'[Shift2])),[Distinct]) Output Best Regards! Yolo Zhu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Distinct sum based on two columns | Microsoft Fabric Community

Forum Discussion

Related content

Count Distinct Values based on another column in Power Query

Distinctive Count across two columns

SUM based on distinct values from another column

Count distinct rows based on multiple columns

Sequential Order column based on multiple criteria