Blank issue in calculated table

[vjnvinod]

Dear all

i have used the below dax, but still i am getting blank, not sure how to resolve this, can someone please help?

EP Competency =
FILTER (
    DISTINCT (
        UNION (
            DISTINCT ( 'Portfolio report FY22'[Engagement Partner Competency] ),
            DISTINCT ( 'Portfolio report FY21'[Engagement Partner Competency] )
        )
    ),
    NOT ( ISBLANK ( 'Portfolio report FY22'[Engagement Partner Competency] ) )
)

[vjnvinod]

This works, thanks very much

[Greg_Deckler · Accepted solution]

@vjnvinod Maybe:

EP Competency =
FILTER (
    DISTINCT (
        UNION (
            DISTINCT ( 'Portfolio report FY22'[Engagement Partner Competency] ),
            DISTINCT ( 'Portfolio report FY21'[Engagement Partner Competency] )
        )
    ),
    'Portfolio report FY22'[Engagement Partner Competency] <> ""
)