Find Employees Not using Power BI

[Anonymous]

Hello, I have a rather specific question. I have used the "Analyze in excel" feature to pull the "Usage metrics" reports from Power BI. I then created a report that shows insight on usage across our entire Power BI platform. 

I would like to find the employees who are not using Power BI but have struggled to discover a measure for this.  I have two tables, one is the full employee list and one is the list of employees who are constantly viewing Power BI as pulled from the Usage Metrics Report. 

Here are screenshots of the partial data:

Please let me know if you have any ideas on a measure or column or table or anything i could do to find the employees on the employee list who are not under the "User" column in the other table because they havent accessed power BI. 

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

We can create a calculated column in your full data table like this.

Column = IF(full[email] in VALUES('Table'[user]),"use","not use")

Pbix as attached. BTW, are the emails fake? If not, do mask your confidential information in your post next time 🙂

[parry2k]

@Anonymous in your employee master list add following measure

Used = COUNTROWS( EXCEPT( VALUES( Table1[Emp] ), VALUES( Table2[Emp Used] ) )) + 

In employee master table visual drop this new measure Used and the one with 0 is not using, you can filter that visual to get list.

Change table and column name as per your model.