Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Group data by ID in PowerBI Service

I have a dataset where I want to group data by ID so that the data only count values for each ID once. I am not able to download nor open the data in the Desktop version, so need a way to cluster the...
Need Help
  • GilbertQ's avatar
    GilbertQ
    4 years ago

    Hi Anonymous 

     

    You could then use the DISTINCTCOUNT function to get it to only count the ID once?

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
4 years ago

Hi Anonymous 

 

You could then use the DISTINCTCOUNT function to get it to only count the ID once?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you, GilbertQ! I solved it by using ID number instead of dummy to indicate the partnerships and then DISTINCTCOUNT. Appreciate your help!

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    4 years ago

    That is great news, thanks for letting us know!