Forum Discussion

BenHoward's avatar
BenHoward
Icon for Helper I rankHelper I
5 years ago
Solved

Using DAX to remove invalid PATH rows

Hi,  I'm using the PATH function in DAX to work out the hierarchy in an organsation, but as usual I have data quality issues which cannot be resolved in the source data.  My HR table has invalid par...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    BenHoward 

    Create a new table:

    New Table = 
	FILTER(
		Table1,
		Table1[Supervisor ID] IN ALL(Table1[EmpID])
	)

     

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

BenHoward 

Create a new table:

New Table = 
	FILTER(
		Table1,
		Table1[Supervisor ID] IN ALL(Table1[EmpID])
	)