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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

vinaydavid , try like 

measure = calculate(count(table1[Logdate]))+0
measure2 = calculate([measure], filter(table1,[measure] =0)

 

Or

measure = calculate(count(table1[Logdate]))
measure2 = calculate([measure], filter(all(table1),isblank([measure]))

 

Measure 2 is one you are looking for