DAX Measure - Selected number has ID that can find another number

[LVCHAO]

Hi,

It's hard to express this by statement, let me give example here. Below is my source data

NUMBER	ID
100	1111111
500	1111111
600	2222222
700	3333333
800	3333333
900	4444444
100	4444444
500	5555555
500	6666666

Only 2 columns - NUMBER and ID, I need to calculate "Recover rate" of each "NUMBER", the critera is find NUMBER "100" on the same ID. 

how could I write this DAX measure?  It blocked me for 1 day.. Really appreciate your help. 

NUMBER	Recovered Rate	Comments
500	33.33%	1111111 recovered because we could find number 100 on it; 5555555 and 6666666 not recovered because we are not able to find 100 records on it; so 1 out of 3 recovered
600	0	600 only found 1 ID = 222222, and there is no 100 number on 222222 found

[Ahmedx · Accepted solution]

Образец файла PBIX прилагается
https://1drv.ms/u/s!AiUZ0Ws7G26RhjgXtzKyuguCQdPP?e=SnDOjp

[Ahmedx]

Is this what you are looking for?

[LVCHAO]

yes exactly - how could I implement this?