Forum Discussion
Solved
Matrix is displaying every combination between two fields despite properly established relationships
I have a fact table with sales figures, a customer table and a product table. And they are set up using the classic star schema where the fact table contains the date, sales, customer ID and product ...
SuddenClarity , Make sure there is no +0 or handling blank or any addition of constant value in your measure
Hi, right click on field Product check if "Show item with no data" off
Thanks for the response. The "Show items with no data" option is already off so that doesn't seem to be the issue 😕
SuddenClarity , Make sure there is no +0 or handling blank or any addition of constant value in your measure
Great catch, it looks like it was caused by my conditional statement to handle the blank values.
Could you elaborate what you did to solve it? Having the same issue
Could you elaborate what you exactly mean and why this should help?
