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
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi vinaydavid ,

 

You may create a new calculated table like DAX below.

 

 

Expected result= EXCEPT (VALUES ('Table 2'[Emp]), VALUES ('Table 1'[Emp]))

 

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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]))