show values from table even it hey don't exist in related table

[jja]

Hi

I have a table Components it consists of all registered components for specific project

I have table transactions where it consists of diferent transactions registered for the components

relationship is 1 to *

My issue if i have a matrix visusal and in this visual i want to show all components filtererd by project name and what is their statuses from trasnaction table. So in this case if this components dies not exist in transactions table it will not be listed in my matrix visual and i want to list it anyway.

Ho do i achieve it?

[jja]

@amitchandak 

You was right. I created a measure with +0 counting to see if there is any transactions and put measure in Values inside matrix. 

Thanks

[jja]

Hi @amitchandak 

On the matrix i don't use any measures. I play pure with table columns

On matrix component name is from Transactions table where it might not cosists of component names and if i make show all data - nothing happens

[amitchandak · Accepted solution]

@jja , Add +0 to your measure.

Or use this option on the project