Forum Discussion
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 relati...
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.
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.