topic Re: Relationship issues showing BLANK values in DAX Commands and Tips

Relationship issues showing BLANK values

Tarek78210 — Thu, 08 Aug 2024 19:28:29 GMT

Hi All,

I built a quick model with a lot of rows (10 million). The model analyses the YOY variances per product product group.

A product reference is linked to a product group. In some cases, the data might have mistakes and 1 reference is linked to multiple product groups.

For some reasons, I can see some "(blank)" values and I don't understand why. When I click on the revenue, it shows nothing as if it is empty.

Could you please help?

Thanks so much for your assistance!

Tarek78210 — Thu, 08 Aug 2024 19:57:43 GMT

solved! How can I delete this post?

Wilson_ — Thu, 08 Aug 2024 20:20:04 GMT

Tarek,

Instead of deleting the post, can you share what you did in case anybody runs into this issue in the future? 🙂

Tarek78210 — Thu, 08 Aug 2024 20:23:50 GMT

I will but I would like to delete the pictures. I changed the format to numbers in both data tables and that fixed the issue