Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Uknown data

I have created a matrix with a parent child hierarchy. 

It's supposed to use data from a table of 300 000 row but, somehow, it gives me a total of 336 000. In addition, there are 50 000 value that are not directly in my table but on a seperated row (in green). But every value should be part of my organization.

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,Anonymous 

    Regarding the issue you raised, my solution is as follows:

    1.First of all, I guess it may be because your table is related to other tables and the other tables can't find the corresponding related values in your table, so there are blank values in the matrix view, please check if your table relationship is affecting your matrix view.

    Here are the relevant links:

    Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

    Relationship troubleshooting guidance - Power BI | Microsoft Learn

    2.If you have measure or calculated columns in the selected values of your matrix, hopefully you can check that they do output the results without problems, i.e. they don't affect your visualization.

    If none of the above solves the problem, can you provide sample data? Or sample pbix after removing sensitive data. We can understand the issue better and help you. Please be sure to delete the sensitive data.

    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.