I want values ​​equal to 0 to disappear.

[Paknanarn23]

I don't want to give out information. in the red frame showing When the Minimum_line_width value is equal to 0

What should I do? please help me

[VatsalyaSolanki · Accepted solution]

Hey @Paknanarn23 ,

Insert this set expression {<Minimum_line_width-={'0'}>}  in the Measure where you are calculating the Sum.

[Paknanarn23]

I can't do it I want dimensions Disappears when the value is 0

[VatsalyaSolanki]

Hey,

I am not sure if you can make the dimensions 'Disappear'  or Blank but you could set them to Null i.e '-'   based on a condition.

 for that you can create a calculated dimension and use the below expression.

=if(Minimum_line_width= '0',Null(),EquipmentNo).

1. Do this for each dimension, just replace 'EquipmentNo' with the respective Dimension name

[Paknanarn23]

This is the code for Minimum_line_width

if(sum(Minimum_line_width) = aggr(NODISTINCT(Mode(Minimum_line_width)),KcePart1,Layer),0,Minimum_line_width)