Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SUMMARIZE error - The Expression refers to multiple columns.

Good Morning.     I have a connection between PowerBI and Jira (our internal help desk) and through that connection, our service types are passed over but are passed over as a code vs. the actual t...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Ok, finally figured it out that I wasn't trying to build the summary as a table.  Not sure how I missed it before but I finally caught it and I have it working now.  

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , ideally this should work

ServiceTotals = SUMMARIZE(Issues, Issues[ServiceType], "Service Types", COUNT(Issues[ISSUE_KEY]))

 

Can you share a sample pbix after removing sensitive data.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yeah, that is what I thought too as I am using that same code 2 other times to show pie charts.  

I have not had to share a PBIX file before, what data actually comes over with the file?  The data that is there isn't sensitive as it is just ID numbers, names and company names, no passwords or confidential data.  I just don't know if the PBIX file includes connections with passwords to the db's.