Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey guys,
Something strange is going on for a while and as I thought this would be fixed with the updates I never care to point it out. But, since this october update didn't make it, here it goes:
I have this cashflow panel that tells me the amount of payables and receivables on a daily basis, but the sum changes wheter I'm using the desktop or the web version of the app.
The tables below show my receivables during a specific amount of time.
This is the info I get when I'm using the desktop version:
And this is the info I get when checking the web version:
Notice the I only covered my personal data, the rest is exactly the same. I know for sure that the web version is showing the right data, but why on heaven do I get doubled values when I use the desktop version? The column "A Receber" shows the amount of money. The report was developed on the desktop version and then uploaded to the web.
Thank you for your attention.
Solved! Go to Solution.
HI @mr_guedes,
After check the newest version pbix file, I found NFS.Nº table seems like contains duplicate records.
I'd like to suggest you try to compare with original data source and tables which transferred by power query to confirm where duplicate records come from.
Regards,
Xiaoxin Sheng
Hi @mr_guedes,
It is hard to reproduce your issue from your screenshots, can you please share a sample file to test?
Regards,
Xiaoxin Sheng
@v-shex-msft wrote:Hi @mr_guedes,
It is hard to reproduce your issue from your screenshots, can you please share a sample file to test?
Regards,
Xiaoxin Sheng
How can I do that? I'm rather new to this forum and can't find a place to share the file.
Hi @mr_guedes,
You can upload your file to onedrive or google drive, then share the file link here.
Regards,
Xiaoxin Sheng
@v-shex-msft wrote:Hi @mr_guedes,
You can upload your file to onedrive or google drive, then share the file link here.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft,
Thank you! You can see the file here
HI @mr_guedes,
I think the issue may related to your calculate column 'Date Recebimento'. If you use 'NFS.Vencimento' as the grouping column of matrix, does this issue appears again?
Regards,
Xiaoxin Sheng
@v-shex-msft wrote:HI @mr_guedes,
I think the issue may related to your calculate column 'Date Recebimento'. If you use 'NFS.Vencimento' as the grouping column of matrix, does this issue appears again?
Regards,
Xiaoxin Sheng
Yes. As a matter of fact, I tried removing every calculated column from the table and nothing changes, as you can see in this new file.
Check it out how I selected just one row (filtered by the column NFS.Nº) in the query editor, and how it doubles the info in the report view.
The file with this filter is here
HI @mr_guedes,
After check the newest version pbix file, I found NFS.Nº table seems like contains duplicate records.
I'd like to suggest you try to compare with original data source and tables which transferred by power query to confirm where duplicate records come from.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |