Show only values that are a present in another table

[BPTBPTBPT]

Hello,

I have a source table with projects. I edited the query in a manner that there are 232 projects left.

I have a second table with projects, but not all are yet entered in this second table. My goal is to see the difference and so see which ones are missing.

The problem though is that this second table gives 471 projects. I guess it is listing also all other projects that are not in the source. I don't need to see those.

What I need to see instead of 471, is the amount of projects that is in source 2, that is also in 1. This would be about 130.

How to achieve this?

By the way, this is the relation:

Where the top table is the source.

Thanks in advance!

[amitchandak · Accepted solution]

@BPTBPTBPT , if there is a relation, just try a measure like

Calculate(countrows(Table1), not(isblank(Table2[Column])) )

Also check

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

[BPTBPTBPT · Accepted solution]

This was the solution. Thanks!

[amitchandak · Accepted solution]

@BPTBPTBPT , if there is a relation, just try a measure like

Calculate(countrows(Table1), not(isblank(Table2[Column])) )

Also check

https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/