I have a requirement where I need to show all values regarding of selection logic on a conditional dimension. If I remove the condition on dimension and simply use a dimension name, show all values works great and show me all categories regardless of the selection on filters
However, If I put a little if condition to the dimension, then it wont show all null or zero data even if I select the show all values and uncheck suppress zero or null data. I need to show all categories/dimension values on the chart even if they have null or zero data within the filters that are selected.
I believe it has something to do the with the conditional dimension. Can someone please tell me how to fix this. Below is a little example of my scenario
I wanted to show all categories of brands even if they did not have any sale. It works fine if I do not use any condition on dimension.
I click on show all values and then in presentation uncheck supress missing or zero. This does exactly what I need
However, I came with a situation where I needed a condition on dimension. For example, show only brands that are from Cosmetic categories. I should show all categories from this brand even if they did not have any sale
If(BrandCat= 'Cosmetic', 'Brand') is my calculated dimension. However, this time, the chart only shows non zero and non null data. IT does not show those brands having null or zero value
Can someone please guide me how to fix this.
P.S: If I took this condition to the measure expression, then It will show all categories and brands since I am showing all values. I need to restrict dimensions to only cosmetic but then show everything in this category even if they are null or zero
