Help with filtering blank rows when there is a second value

I would restructure the data so that you have 3 tables :

• Employee, contains a row for every employee
• Training, contains a row for every training course
• Bridge, contains a row for every combination of employee & training course where the employee has completed the training

Create one-to-many relationships from Employee -> Bridge and Training Course -> Bridge.

You could then create a visual showing Employee[Name], create a slicer for training course and put a filter on the table / matrix to only show rows where Bridge[Employee] is blank.

Hi,

Write this measure and drag it to the Filter o n this visual group in the Filter pane.  Apply a condition of equals 1

Measure = 1*(countblank(Data[Training])=countrows(Data))

Hope this helps.