Hierarchy error

Hi Anonymous ,

Even if without dax measure is being used neither any relational table.Using different hierarchical structures in the rows can also affect the results. Specific needs according to your needs.

When you drill down further, In the last row in 2021 disappears because the corresponding row "DEUDA BANCARIA" can only count the summary value corresponding to 2021, not the further subdivision value. If you add a hierarchical structure to the row, the correct statistical result will be displayed in the value.

I did a test, refer to the following:

If the problem is still not resolved, please provide test data (delete sensitive information), I will answer you as soon as possible. Looking forward to your reply.

Best Regards,
Henry

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