Need Correct count fromfrom second table

[chotu27]

Hi All,

I have two tables

1. Table 1 has = appid, app name, migration year,  Cloud type

Apps list (Table 1)Server list (Table 2)

2. Table 2 has = appid, server name

Table and table 2 has relationship between appid

My goal is i want year by apps count with related to their servers which are associated to apps

Suppose  in 2019 there are two apps migrated and their related server are server 1 and server 3 but these servers are available in other apps so i need that count also to be added

final answer so for 2019 there are 8 apps that should be migrated 

[v-chuncz-msft]

@chotu27 ,

You may check if the link below helps.

https://www.sqlbi.com/articles/the-in-operator-in-dax/