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,...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
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