Forum Discussion

Truelearner's avatar
Truelearner
Helper III
6 years ago
Solved

grouping data for custom category

Hi ALL, i have data of an emp login who works for multiple clients , employee logs hours he worked for each client he worked for and i have summaried the total hours employee worked on a day in a col...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi  Truelearner ， 

    You could try below measure and refer to my sample for details.

    Measure 2 = COUNTX(SUMMARIZE('Table (2)','Table (2)'[Emp],'Table (2)'[Date],'Table (2)'[status]),'Table (2)'[status])+0

     

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Truelearner's avatar
Truelearner
Helper III
6 years ago

can someone from community support take a look at it please 

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Truelearner can you share pbix file with sample data and expected output and I will look at it. My solution answered the original question you posted but seems like there is more than that.