cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lizrowden Regular Visitor
Regular Visitor

Group data rows by 'count distinct' value

I am trying to get a count of the # of units serviced and having a difficult time. I feel like I have tried everything from the posts, but nothing is working. Below is a snapshot of the data and to the right (in red), the expected result. I need to get the # of units serviced on a call-by-basis, but also need the # of units serviced by each technician.  

Any help would be much appreciated. Thanks

group by distinct sample.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Group data rows by 'count distinct' value

@lizrowden add new measure for calls by serial #

 

Calls by Serial # = 
DISTINCTCOUNT( CallDetailTable[ Call# ] )

drop table visua, and put serial # and Calls by Serial # and you will get the result

 

similar way you can add another measure for technicians

 





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




3 REPLIES 3
Super User
Super User

Re: Group data rows by 'count distinct' value

@lizrowden add new measure for calls by serial #

 

Calls by Serial # = 
DISTINCTCOUNT( CallDetailTable[ Call# ] )

drop table visua, and put serial # and Calls by Serial # and you will get the result

 

similar way you can add another measure for technicians

 





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




lizrowden Regular Visitor
Regular Visitor

Re: Group data rows by 'count distinct' value

I appreciate your response, but I'm sorry I do not understand. Using a distinctcount by call # does not give the expected result. Perhaps you could provide clarification on the following...."drop table visua, and put serial # and Calls by Serial # and you will get the result"

Super User
Super User

Re: Group data rows by 'count distinct' value

@lizrowden can you share sample pbix file using onedrive/google drive and get you the solution.





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.