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

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