Forum Discussion

cityofglass88's avatar
cityofglass88
Frequent Visitor
8 years ago

Group by Total

Can't get my head around this requst and just looking to be pointed in the right direction. I'm connected to a SQL dataset for ticket data. Relevant colums:      Ticket ID |  User ID | Facility | *...
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi cityofglass88

 

If I understand your scenario correctly, your expect result is the matrix visual you provide under the Issue.

 

I try to reproduce the scenario as yours. There’s a simple way for you to group without write the SWITCH function, you could you use NEW GROUP to make a group. Then, do a measure like below:

Tickets = DISTINCTCOUNT(Table1[Ticket ID ])

 

If you don't know how to create group, you could refer to this article.

 

The below picture is the my test result, you could refer to it.

 

For details, you could refer to my demo pbix file here.

 

Could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best Regards,

Cherry