Direct and Indirect Report

The only problem is I am seeing the blank when I expand the tree. Is there a way to remove the blank from the visual?

Not unless you want to go to extremes with ISINSCOPE, or are willing to use the hierarchy slicer visuals that traverse the tree for you.  With your hierarchy size that will already incur a meaningful time penalty.

Note that you don't need to do that much of a cleanup.

let
    Source = Csv.Document(File.Contents("C:\Users\xxx\Downloads\Hierarchy data.csv"),[Delimiter=",", Columns=4, Encoding=65001, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Replaced Value" = Table.ReplaceValue(#"Promoted Headers","",null,Replacer.ReplaceValue,{"LEADER_ID"})
in
    #"Replaced Value"

And SELECTEDVALUE makes little sense in calculated columns. Streamline your data.

level_2_NAME = var e = PATHITEM([path],2) return MAXX(FILTER(ADM,[EMPLID]=e),[NAME])