Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hey @Paknanarn23 ,
Insert this set expression {<Minimum_line_width-={'0'}>} in the Measure where you are calculating the Sum.
Hey @Paknanarn23 ,
Insert this set expression {<Minimum_line_width-={'0'}>} in the Measure where you are calculating the Sum.
I can't do it I want dimensions Disappears when the value is 0
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
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)