Forum Discussion

vinaydavid's avatar
vinaydavid
Icon for Helper III rankHelper III
6 years ago

Except function with a filter - unlogged employees

Hi All,   Want to achieve the below result from the 2 unrelated tables.   Table 1 - Logged employees list with logdate Table 2 - Complete list of employees (without logdate) Everyday I get a li...
Need Help
vinaydavid's avatar
vinaydavid
Icon for Helper III rankHelper III
6 years ago

v-xicai 

Table 1 contains history. So, is it possible to restrict using FILTER in EXCEPT?

 

amitchandak 

Tried using the measures you suggested, but not successful.

How are these measures cross checking Table2?

 

NOTE: There is no relation between Table1 and Table2. Avoided because of other calculations.

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

vinaydavid , Try

Measure = 
CALCULATE(COUNTX(filter(Table2,Table2[Emp] in EXCEPT(ALL(Table2[Emp]),ALL('Table 1'[Emp]))),[Emp]))