Filter out column from matrix if leading value is blank

[Anonymous]

Hi,

How do I remove this column category from the matrix if a certain measure value is blank? In this case it will be Number 02 because the Sales $ CY is blank.

Thank you for any help!

[Anonymous]

@amitchandak 

Thank you, that worked! 🙂

[amitchandak · Accepted solution]

@Anonymous , If yo do want display value for 2 when Sales CY is blank. then you can use visual level filter Sales CY is not blank

or all the measures have to use it

Sale PY new = if([sales CY]<> Blank(), [Sales PY], blank())