Forum Discussion

mavbaumer15's avatar
mavbaumer15
Frequent Visitor
5 years ago
Solved

Data Always Loading on Report as 0

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 ...
Need Help
Show and Tell
  • mavbaumer15's avatar
    mavbaumer15
    5 years ago

    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's avatar
jdbuchanan71
Super User
5 years ago

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's avatar
mavbaumer15
Frequent Visitor
5 years ago

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....