cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
achase Regular Visitor
Regular Visitor

Find Employees Not using Power BI

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:

22.PNG222.PNG

 

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. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Find Employees Not using Power BI

Hi @achase ,

 

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

 

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

Capture.PNG

 

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

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Super User
Super User

Re: Find Employees Not using Power BI

@achase 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.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Community Support Team
Community Support Team

Re: Find Employees Not using Power BI

Hi @achase ,

 

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

 

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

Capture.PNG

 

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

 

 

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

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 33 members 867 guests
Please welcome our newest community members: