Help:Count number of id with condition

[Datavizuserpbi]

Hello,
I have 2 tables ,table 1 and table 2 are joined by ID, i create a mesure 

Measure=Table1[Mes1]/Table2[Mes2]

With filter on year in 2021 :

ID	Measure
R1	BLANK
R2	x
R3	y

With filter on year in 2022 :

ID	Measure
R1	z
R2	x
R3	y

How can i countrow table with condition 1= measure >=0 and condition 2=measure <>Blank
I want the number of id with measure >=0 without line with blank measure.
I try countrow(relatedtable(table2),table1[Measure]>=0) but for 2021 i have 3 and It should be 2 ( R2 and R3 without R1 because it's <0)
Thank for your help!

[amitchandak]

@Datavizuserpbi, Try like

Countx(filter(summarize(ID, ID[ID], "_1",[Mes1], "_2", [Mes2]), [Mes1] >0), [Mes2])

[Datavizuserpbi]

It's not working, when i'm using date filter i have blank for 2022

[v-easonf-msft]

Hi, @Datavizuserpbi 

Not fully sure what you want.

Could you share your example file to further illustrate your problem?

Best Regards,
Community Support Team _ Eason