"Show Items With No Data" causing problems; other data goes missing!

[s-turn]

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.

[s-turn · Accepted solution]

 An update - I haven't figured this out, but I have developed a satisfactory workaround.  The workaround is a measure:

SpecialRequestDesc = CALCULATE(MIN(SpecialRequests[SpecialRequestDesc]))

[s-turn]

Oh and just to add to my problems, there are now some rows that only show the SpecialRequestDesc!

[s-turn]

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.

[amitchandak]

@s-turn , what is source data. Assuming the table you shared is the expected output

Usually a measure like this should work =  sum(PaymentAmount)+1