Forum Discussion
Wrong/redudant data after refresh
Anonymous ,
How do you design the Power BI report? Do you apply any filter or slicer in the report? Could you please post an example about "redudant data"? We need to know that if additional columns or additional rows are added in Power BI visuals.
Regards,
Lydia
Hi Anonymous,
Thank you for your response.
I'm going to try to give you an explanation on how the report has been build. I have two views: One with budgets and one with actuals. I have connected these views based on the projects for which they are meant. In order to do so, I used the summarize function to create a new table that includes all unique projects inside the budget view and then connected the two views to this table.
Maybe it's worth mentioning that the budget view is based on months and the actuals view is based on dates. I found out that, when it goes wrong, the data for the actuals give really high numbers.
Furthermore, I have created a simple date table with DAX and a small custom table that allows me to connect projects to certain departments.
I indeed do use several filters and slicers. Most noticable are the dates, departments and projects.
My statement about redundant data is not based on facts. Since the values in my report were heavily inflated while something went wrong, I assumed that it had something to do with redundant data. But to be honest I'm not completely sure that the data was in fact redudant.
Hopefully some things are more clear right now and you may be able to help me further to find the cause of the problem.