I have a chart in which I need to list values (unique unit numbers) that 'Fulfilled' an 'Obligation Due' that are required by certain dates.
In the following screen shot, you can see that I can get the unit number to list if there's only 1 unit number that fulfilled a single obligation on that date. However, the chart doesn't list the Unit numbers if there are multiple "Fulfilled' obligations required by a certain date:
Ideally, it would be nice if the multiple fulfilled obligations could be displayed in their appropriate cell and separated by comma.
Your expression doesn't explicitly use an aggregation function. In that case the Only() function is used. And the only function can only return a value if there's only one possible value. That's why you see no result for the rows where there are two or more values. If you want a list of values you can use the concat function like Piet Hein van der Stigchelposted above..
When I tried Piet's recommendation, this works on individual dates (thanks for that!). But, now the problem is that I have totals turned on in the chart, and there's so many "Fulfilled" unit numbers, it makes the chart unreadable. So, can I now suppress those 'Fulfilled' numbers from listing out in the "totals' line?