Table doesn't show all registers

[feralvarez994]

Hi everyone! I have an issue here, i have a table in PBI desktop with all the details from some bookings, most of them are from a table called AUTOS, but the thing is that when i add a column from another table (VENDE, column name VE_APELLIDO) it shows me less registers than before adding it (example, i have 1000 bookings and when i add VE_APELLIDO there are only shown 700).

The thing is that i have an intermediate table that doesn't contain any register for that bookings, but i do not want it to remove those rows for not having any linked value, i'd prefer to show the row anyway with a blank value instead. How can I do that ?

Thanks you all!

[v-rzhou-msft · Accepted solution]

Hi @feralvarez994 ,

This should be caused by relationship. I think VENDE table doesn't have all values in intermediate table.

I suggest you to try "Show items with no data" function in your visual.

Or you can try change the relationship direction from single to both.

If both ways above couldn't solve your problem, I suggest you to create a measure to calculate the result then use "Show items with no data" function in visual.

Measure looks like as below. If VE_APELLIDO column is number format, you can use SUM in your code. If VE_APELLIDO column is number format, you can use SUM in your code. If VE_APELLIDO column is text format, you can use MAX in your code.

MEASURE = 
CALCULATE(SUM/MAX('VENDE'[VE_APELLIDO]),FILTER(ALL('VENDE'),'VENDE'[COLUMN1] = MAX('AUTOS'[COLUMN1])))

If this reply still couldn't help you solve your problem, please share a sample file with me and show me the result you want.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahenkj2]

How do you add other table's column, in power query by merge? or through DAX as calculated column or just see in the visual using relationship? You should clarify the things little more, with some sample data.