Forum Discussion
Uploading 2 Dataset - Sum function disappearing for one Dataset
Dear All,
I have uploaded one data set into power-bi and it works perfectly.
However, if I upload another one in the same file, the sum option disappear in one dataset.
Do you know what went wrong?
Thanks
M
BeforeAfter
Hi v-ljerr-msft,
I simply added an additional dataset into my Power bi view and suddenly the dataset that did not have the aggregate symbol was working.
I know that this is not a proper fix, but still made the job.
Thanks
Marco
4 Replies
v-ljerr-msftMicrosoft Employee
Hi Sciupo,
According to your description, I just tested it on my side by importing data from the same Excel file. And I was not able to reproduce the issue.
What's your data source for your dataset? Are you using the latest version of Power BI Desktop(2.42.4611.701 64-bit (January 2017))?
In addition, could you share a sample pbix file which can reproduce the issue? So that we can further investigate the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.:smileyhappy:
Regards
Hi,
I have managed to fix it.
Thanks for your support anyway.
Thanks
M
- v-ljerr-msft
Hi Sciupo,
Great to hear the problem got resolved! Would you mind being more precisely with how did you fix the issue to help others who may have similar issue? Could you also accept your last reply as solution to close this thread?:smileyhappy:
Regards