Table does not show all data with left outer join

[Syndicate_Admin]

Hello everyone.

I am having difficulty finding a solution to this problem. Here's what I explain:

I have a table called DATA TRELLO. In it, each number belongs to a candidate who applies for a job and has his typical data such as the position to which he applies, the stage in which he is, his experience, etc. Here's an example:

I have the problem when I want to add columns that belong to other tables. For example, when I want to add the exam column of a product (which is in a different table ("Product Scores" table) to the one with all the data above) the following happens:

It simply stops showing the rows that don't have the "score" field filled in. If I also add another column from another table, what it does is add the rows that have "CRM Score" as if making a left join of the main table with the other two tables.

The model is connected as follows:

I've avoided applying cross filter in both directions to see if that fixed my problem with the table but it didn't work either. I also tried to merge between the "DATA TRELLO" table and the "product score" and "CRM score" tables using left outer join to add the exam score data directly from the DATA TRELLO table but the same thing still appears.

Is there anything I'm thinking of? Do you know what may be happening?

Thank you very much and greetings.

[amitchandak]

@Syndicate_Admin , try this option or add a measure with +0

eaxmple countows(Data_terllo) +0

[Syndicate_Admin]

It worked. I've simply had to look for the option in a field other than scores.

Thank you so much!