Filter does not work in a measure

[vika160]

HI there,

It maybe a silly question, please, forgive me,  but I think it is crazy.

I have a table with column that has "IN" and "OUT" only value.

I need 2 very simple measures.

 Exams IN = CALCULATE(count(V_PBI_EXM_DATA1[ID]), V_PBI_EXM_DATA1[ExamProvider]="IN")
_Exams OUT = CALCULATE(count(V_PBI_EXM_DATA1[ID]), V_PBI_EXM_DATA1[ExamProvider]="OUT")

First measure works and return a correct value, second measure returns BLANK.

I  also tried this ways and it is the same BLANK value return: 

   Exams OUT = CALCULATE(count(V_PBI_EXM_DATA1[ID]), V_PBI_EXM_DATA1[ExamProvider] <>"IN")

_Exams OUT = CALCULATE(count(V_PBI_EXM_DATA1[ID]), FILTER(V_PBI_EXM_DATA1, V_PBI_EXM_DATA1[ExamProvider]= "OUT" ))

_Exams OUT = CALCULATE(count(V_PBI_EXM_DATA1[ID]), FILTER(V_PBI_EXM_DATA1, V_PBI_EXM_DATA1[ExamProvider]<> "IN" ))

Note:

there are no empty or null values in [ExamProvider] field, onlu IN and OUT

 In Power BI in  table  view mode I can see both values.

Any idea?

Thanks a lot!

[vika160]

I deleted the table form PBI and relinked it again. it is working now. So strange. 
Thank you for your help!

[HotChilli · Accepted solution]

powerbi/dax can be strange (but it will follow logic).  You might have seen the "auto-exist" problem but I would have to see the original pbix to know for sure. 

[vika160]

I have a lot of data there that I cannot share. That is why I was trying to create new pbix with 2 tables only and stripped fields.  Is there a way to guide me where amd what  to look for?

[vika160]

Hi @HotChilli,

I created new pbix and did a table copy with few columns only. imported Calendar table.

Both measures seems work properly.

If I link 2 filtered tables to my original  pbix - one for IN and another for OUT -- measures work as well.

 I am wondering if there is something in a table I have to look for? 

 still it is strange but you never know.

Thank you

[HotChilli]

Can you provide the pbix please and I'll have a look