Hide a null dimension but keep associated calculated measure.

[Anonymous]

Hi, I have a dimension that shows up as null but has quota information on it that I need. I want to hide the "-" but keep the 544,023 that shows up at the bottom. The problem I have is that if I click "suppress null values" under Model then the 544,023 is not calculated. How can I keep the amount in the null value but hide the null dimension itself?

Model	Brand	Quota
CAPITAL	PLYO	$0
DEVICE	PLYO	$0
DEVICE	CYNO	0
OPTIONS	PLYO	$0
-	CYNO	$544,023
		$544,023

So I want it to look like this:

Model	]Brand	Total Quota
CAPITAL	PLYO	$0
DEVICE	PLYO	$0
DEVICE	CYNO	$0
OPTIONS	PLYO	$0
		$544,023

[sunny_talwar]

May be dimensionality() function can help you do that

How to use - Dimensionality()

[Anonymous]

I actually am using dimensionality but it does not help with hiding the null value.

[sunny_talwar]

Would you be able to share a sample where you are doing this?

[Clever_Anjos · Accepted solution]

Please try using calculated dimensions

1. Aggr(IF(isnull(Model),'',Model,Model)
2. Aggr(IF(isnull(Model),'',Brand,Model,Brand)

[OmarBenSalem]

Try as dimension:

=if(len(trim(Brand))=0,'',Brand)

result:

[Anonymous]

Thank you! a variation of this worked for me.

[Anonymous]

Thank you, Omar. The isnull expression above worked for me so I did not test this solution but I greatly appreciate the response!

[Clever_Anjos]

Cleaner with the new coalesce function

Aggr(Coalesce(Model,''))