Forum Discussion
"Show Items With No Data" causing problems; other data goes missing!
Hello,
I'm trying to produce what should be a very simple table visual. The first four columns are from my Payments table, and the final column is from a table called SpecialRequests. The SpecialRequests table has a many-to-one relationship with the Payments table. Most rows in Payments do not correspond to any SpecialRequests, but some do. I want to see all Payments (within the filter context), and any SpecialRequest data that may exist.
For example, it should look like this:
| PaymentDate | PaymentAmount | PaymentCustomerName | PaymentCode | SpecialRequestDesc |
| 01/03/2021 | £200 | Jackson | 5555 | |
| 03/03/2021 | £75 | Miller | 5412 | Item to be personalised |
| 03/03/2021 | £100 | Smith | 1233 |
In theory, this should be easily accomplished by setting "SpecialRequestDesc" to "Show items with no data".
However, when I do that, data starts disappearing from the other columns! Some rows lose their PaymentAmount and PaymentCode, other rows lose their PaymentAmount and PaymentCustomerName, some lose the PaymentAmount only.
All rows in the Payments table have the above-named fields populated, so it's a mystery why the data disappears from the visual.
Any clues appreciated! Thanks in advance.
4 Replies
Anonymous , what is source data. Assuming the table you shared is the expected output
Usually a measure like this should work = sum(PaymentAmount)+1
Hi amitchandak , the source data for these columns does not contain any measures. I'm just looking to output single transactions, not aggregations. However, the PaymentCode column is a calculated column.
Yes, the table I shared is the expected output.
