Forum Discussion
When adding columns from another table, rows from first table disappear
Do you want to see, for example, the total licences purchased for department A and then those currrently issued at employee level to that department so say 15 purchased and 10 issued?
If so you shouldnt need a measure
Simply add the bolean field as a value, eg count of bolean, to your visual and filter it on Yes (assuming your bolean are either Yes or No)
This should then give the visual you need
I'l add a screenshot if I can figure out howto in this forum
Thanks a lot, you understood exactly what I would like to achieve (purchased vs issued). I reproduced on my side as well by removing the measure and using the count+filter as you described. This works to remove the measure, however my problem remained the same: once I added the 'Count of Issued' to the table, several rows from Table A disappear.
I notice in your example you used 'Sum of Purchased', where I was using just 'Purchased' with 'Don't summarize' selected. When using 'Sum of Purchased', all rows from Table A indeed are kept while adding the 'issued' column, which was my goal. Thanks!
Could you help me understand however why rows would disappear when not summarizing the 'Purchased' column? I'm not sure I understand the difference between the 'Sum' or 'Don't summarize' in this case, as the values in the column seem to remain the same.