Forum Discussion
Making a Table based on grouping multiple Columns - Columns Show Same Values
I wanted to create a new table of city complaints based on "a group by". The idea was to group by type of complaint, then by count of the complaint, and then bycount of zip code. My DAX code to this end is:
Table = SUMMARIZE('erm2-nwe9', 'erm2-nwe9'[complaint_type], "Quantity of Incidents",Count('erm2-nwe9'[unique_key]), "Zip Codes Reporting",Count('erm2-nwe9'[incident_zip] )
However the table I get is giving me the same numbers for both of the quantitiative columns. I don't understand where my error is. Thank you for your help.
2 Replies
Please follow the recommendations in this thread to help us help you:
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi, JonSilverman
Could you please tell me whether your problem has been solved?
If you still need help, please share a sample file for further research.
Best Regards,
Community Support Team _ Eason
