Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Table rows expand when dimension column added

 

Hi all,

I have created a measure (OrdersInFull) that gets a count of how many orders are "In Full". The measure works fine until I add "ProductName" from the product dimension (one to many relationship Product -> Sale). When I add "ProductName" to the table, the rows increase to display every possible product for every line in the Sale table. Why does this happen? 

 

Calculation for the measure (probably whats causing the issue :smileyfrustrated:) is also in the screenshot below. On the left you will see the table without the "ProductName" field, displaying correctly. The table on the right shows what happens when I add ProductName. Any help on this is much appreciated.

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    You're adding 0 to every count in that measure, so there are no blank values. Every product gets a 0, so it has to display.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks for that. I was sure this is intended behaviour. However, if I remove the zero (allowing blanks) then if I have a similar table to my original post except without the saleLine included, then the table only shows orders where "InFull" = "Y", I need it to show all orders regardless of if its infull or not. Is there any way I can improve my measure to do this? Thanks again for your help.