Forum Discussion

vika160's avatar
vika160
Icon for Helper III rankHelper III
4 years ago
Solved

Filter does not work in a measure

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 = ...
Need Help
  • HotChilli's avatar
    HotChilli
    4 years ago

    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's avatar
vika160
Icon for Helper III rankHelper III
4 years ago

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