Total Column returns zero for calculated measure

[Anonymous]

Hi guys!,

I have a measure I created where if it equals to this chain it will return zero, I got the correct output but when I tried putting a total column values does not show only returns zero, how to return the total for each column even with zero in another column

[TeigeGao]

HI @Anonymous ,

Could you please share the pbix file to us for analysis?

Best Regards,

Teige

[Anonymous]

@TeigeGao 

Hi yes here is the file

you can download here

https://drive.google.com/open?id=1epfvyS6oSIkCpAH0li01cy4dhmDv_fTM

also I just wanna add the reason why I want it to be zero is to be able to manipulate the field containing the Chains (Bellings, Ready Wear) I want to see that even if ready wear has sales I want it to be valued as a null column which will hide the column itself and the total and grand total to show the remaining total of the columns. but I still need the process of zeroing values so that if ever I choose to add more items to CHAIN field I would be able to choose who I want to zero out and who should be added to the total columns

here is a screenshot of my to be output