Data Always Loading on Report as 0

[mavbaumer15]

Hi, 

I have never seen antyhing like this before... I had created this report a long time ago and now all of sudden this week the amount column on the dataset will only show as 0.  If I got into transfrom data it shows up as expected and there's values in there.  I have tried to create a new SQL view, remove and re-add the dataset, and even a brand new report but the same result everytime. I ended up find out that it's taking the decimal places out 15+ places like it's being divided or something?

Has anyone seen anythign like this before in PBI desktop?

 

[jdbuchanan71]

Not at all, glad you were able to find a fix!

[jdbuchanan71]

It seems like the total is summing to 0?  I exported to excel and the sum of the REPORTINGCURRENCYAMOUNT is 0

so I added a Sign column to your table to split it up to check.

Sign = 
SWITCH(
    TRUE(),
    VendorInvoiceTransactionsWithGLDetail[REPORTINGCURRENCYAMOUNT] < 0, "-",
    VendorInvoiceTransactionsWithGLDetail[REPORTINGCURRENCYAMOUNT] > 0, "+",
    "0"
)

This is the measure in the values

Measure = SUM(VendorInvoiceTransactionsWithGLDetail[REPORTINGCURRENCYAMOUNT])

with the sign column on the columns.

[mavbaumer15 · Accepted solution]

I'm not seeing the same thing...so sorry about this.  I'm not sure what happened with our data but I think I have found the issue and am fixing it in the backend. Thanks for looking at this and sorry for wasting your time. 

[jdbuchanan71]

Any chance you can share your .pbix file?  You can load it to OneDrive or DropBox and share the link here.

[mavbaumer15]

Yup I stripped it down to just this tab where the issue is. 

https://rentptr-my.sharepoint.com/:u:/p/mav/EQ1gNgUSIrlLgCfJFBjZ6mwBQqEcQz1xtO1lC191Em_6sA?e=tC7vPa

[jdbuchanan71]

Try writing a measure to sum the column and put that in the visual.  It's possible that the data type got switched so your aggregation on the implicit measure went from sum to first or something like that.

[mavbaumer15]

I just tried this and it's still showing 0.  Something I did try as well was switching the value to Don't Summarize and now I have values.  I just exported everything to excel and summed it up by vendor to make sure it's not actually netting to 0 and they are not.  I've had created 100s of PBI reports before and never seen anything like this....

[jdbuchanan71]

@mavbaumer15 

Are you using a measure in your display to sum the ReportingCurrencyAmount column or did you just drag the field in from the table?

[mavbaumer15]

Hi, no measure I'm just directly using the field from the table.