Forum Discussion
Reverse filter for multiple selections
I'm doing analysis on Microsoft 365 licenses assigned to accounts in Entra ID. As some organisations have a requirement for certain license assignments per account, for example O365 E3 and EMS E3, I'...
Create a one to many relationship between the Licences table and teh USer table on the Licence column.
Add the Column from the Licence Table to a table visual then the User Principal Name too. On the right side of the screen go to the Build Table and right click on one of the column names and choose the option "Show items with no data"
Hope this helps
Joe
Thanks for your response, Joe_Barry . Unfortunately it gives me all users with any of the licenses selected, rather than those with only the selected licenses.