Forum Discussion

SuddenClarity's avatar
SuddenClarity
Helper I
3 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
    3 years ago

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

SuddenClarity's avatar
SuddenClarity
Helper I
3 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
Super User
3 years ago

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

  • SuddenClarity's avatar
    SuddenClarity
    Helper I
    3 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?