Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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())
@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())
User | Count |
---|---|
98 | |
90 | |
84 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |