Forum Discussion
2 Dataset Calculation
Hi, Anonymous
I checked your .pbix file, but the file is too complicated, it is difficult to see the specific problem. I did some attempts. If you think which data is incorrect, you can point it out.
Like this:
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
It’s my pleasure to answer for you.
I think you may be a bit confused about the concept of report and dashboard.
A report is based on a dataset. A dashboard can be used to present visuals of different reports but can’t be used to calculate content from different reports.
So even if visuals of two reports are pinned to the same dashboard, the operation of calculating data in different datasets can’t be realized.
I suggest that if you want to implement calculations, you can merge the contents of two reports into one report. One report can connect to multiple data sources, and you can create multiple report pages to meet your needs.
If it doesn’t meet your requirements ,could you please share more details about your requirement and share some sample data?
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
you are right. i merged and tried the calculation but the % doesnt seems to be right.
https://drive.google.com/file/d/1l4p-mSlu_mO3Xeeu9fgTz8P8sQMOKrdA/view?usp=sharing
you may download the file from the above link.
Hi, Anonymous
I checked your .pbix file, but the file is too complicated, it is difficult to see the specific problem. I did some attempts. If you think which data is incorrect, you can point it out.
Like this:
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.