Count if a variable is related

[AnneMi]

Hi, 

How can I count how many of column: "number" that has a value in column "Test" that is related to table "Special". 

I have two columns in table 1: "Number" and "Test". I want to know how many number that has the same value in "Test" and "Special".  

[AnneMi]

Thanks for the answer. If I do the first suggestion; How do I write the dax? 

I tried the erarlier, but I got an error-message. 

Do you know if there are other options? 

[amitchandak]

@AnneMi , where is sepcial.

One way is to have a common table of numbers and then join with both columns and count them. With inactive join, you will use userelationship

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...

Another one is count column like

countx(filter(Table, Table[Special] = earlier(Table[Tes]) ), Table[Special])

Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

[AnneMi]

Hi, Thanks for the answer. I got this results: 

But I just want to know how many of "Number" that has a special value. In this case, it is 1 for 1, and 1 for 10.