Forum Discussion

Aucesar's avatar
Aucesar
Helper III
3 years ago
Solved

Distinct sum based on two columns

Hi Community,   Tried to count how many products the employee worked, sounds easy at the beggining but I cant count the second column.   Tried usuing DISTINCTCOUNTNOBLANK, but I can´t tell PBI ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

 

 

 

Aucesar's avatar
Aucesar
Helper III
3 years ago

Hi Anonymous , Ahmedx , Dhairya  thank you all! Worked like a champ!

  • Dhairya's avatar
    Dhairya
    Solution Supplier
    3 years ago

    Hey Aucesar 
    If the provided solution helps you then please give it a kudo and mark my solution as accepted so that other can find it quickly on facing similar issue. Thank You!