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

Hi,

Try this

1. Create a Calendar Table and build a relationship from the Logdate column of Table1 to the Date column of the Calendar Table

2. Create a relationship from the Emp column of Table1 to the Emp column of Table2.  There should not be duplicate Emp's in Table2

2. Create a slicer from the Date column of the Calendar Table

3. To yoru visual, drag the Emp from Table2

4. Write this measure

=Countrows(Table1)

Hope this helps.