This is what I could manage. let me know if this helps in some way. While creating action from difference it takes all the 3 employees, which I couldn't fix.
Output (After action)
Ivan Young, can probably the best person to help us out.
Thanks and Regards,
Employee.twbx 23.7 KB
Hi Parag and Ashish,
Thanks for pinging me, I'm on 9.2 so I can't open your twbx Ashsih. I'm not entirely clear on how the two data sets are related but I'm going to assume that we are blending. In order to generate the desired output using blending we are going to make Excel 1 the Primary and Excel 2 the Secondary data source.
Once the data sources are set up we create our Measures.
Primary Name Count: COUNTD([Name]) - Create this as a Measure for Excel1
Secondary Name Count: COUNTD([Name]) = Create this a Measure for Excel2
Not in Secondary: [Primary Name Count] - [Sheet2 (Not In)].[Seconday Name Count] - Create this as a Measure for Excel1
We then create our source sheet. - When we select a measure we want to display the records that are in the Excel 1 with no match in Excel 2.
We then create our target sheet.
The trick to getting the output correct is to use the secondary data source Name as an exclude filter. We will exclude all non-null values.
Then we put it together on a dashboard and create our action filter.
Attached is a twbx. Let me know if you have any questions.
Not in Secondary.twbx 17.3 KB