Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Total Column returns zero for calculated measure

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

 

General Comment
Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    HI Anonymous ,

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

    Best Regards,

    Teige

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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