Measure not showing value in the table visualization but showing total at the bottom

[Anonymous]

Hi 

I am trying to create a report using 3 columns from two different tables. 

Column A	QTY
ABC	2
Total	2

Column A and QTY are from same table, so when I put them in a table visualization I do not see any problem. But when I add ID column from another table I am seeing data like below

Column A	QTY	ID
ABC
Total	2

I see the total value but cannot see value see value in cell. Both tables are related. I enabled 'Show items with no data ' on 'Column A' and saw the same result when I enabled 'Show items with no data' on ID column. If I do not enable 'Show items with no data' on those columns I am seeing a blank table visualization. When I query with these same values in my SQL database I can see value.

Any suggestions...

[v-eachen-msft]

Hi @Anonymous ,

You could edit the relationship between two tables.

"ID" column may not match any column in the first table.

[nahid3152]

HI,
can u share ur file or something to see the visual