Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Make sure there is no +0 or handling blank or any addition of constant value in your measure

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for the response. The "Show items with no data" option is already off so that doesn't seem to be the issue 😕

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Make sure there is no +0 or handling blank or any addition of constant value in your measure

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Great catch, it looks like it was caused by my conditional statement to handle the blank values.

    • nospang's avatar
      nospang
      Frequent Visitor
      3 years ago

      Could you elaborate what you did to solve it? Having the same issue

    • ZooTV's avatar
      ZooTV
      Frequent Visitor
      2 years ago

      Hi

      I am having a similar issue.

      Are you able to describe how the suggestion "Make sure there is no +0 or handling blank or any addition of constant value in your measure" worked for you?
      Can you share how you fixed it?

      Many thanks

  • nospang's avatar
    nospang
    Frequent Visitor
    3 years ago

    Could you elaborate what you exactly mean and why this should help?