How to restrict blank values in a UNION DAX

[Anonymous]

Below is my table formula,

NewTable =

UNION (

SELECTCOLUMNS (

'Staffing Report',

"Manager", 'Staffing Report'[Level_1],

"NT_UserName", 'Staffing Report'[NT_Username],

"Level", "1"

),

SELECTCOLUMNS (

'Staffing Report',

"Manager", 'Staffing Report'[Level_2],

"NT_UserName", 'Staffing Report'[NT_Username],

"Level", "2"

),

SELECTCOLUMNS (

'Staffing Report',

"Manager", 'Staffing Report'[Level_3],

"NT_UserName", 'Staffing Report'[NT_Username],

"Level", "3"

),

SELECTCOLUMNS (

'Staffing Report',

"Manager", 'Staffing Report'[Level_4],

"NT_UserName", 'Staffing Report'[NT_Username],

"Level", "4"

),

SELECTCOLUMNS (

'Staffing Report',

"Manager", 'Staffing Report'[Level_5],

"NT_UserName", 'Staffing Report'[NT_Username],

"Level", "5"

),

SELECTCOLUMNS (

'Staffing Report',

"Manager", 'Staffing Report'[Level_6],

"NT_UserName", 'Staffing Report'[NT_Username],

"Level", "6"

),

SELECTCOLUMNS (

'Staffing Report',

"Manager", 'Staffing Report'[Level_7],

"NT_UserName", 'Staffing Report'[NT_Username],

"Level", "7"

),

SELECTCOLUMNS (

'Staffing Report',

"Manager", 'Staffing Report'[Level_8],

"NT_UserName", 'Staffing Report'[NT_Username],

"Level", "8"

),

SELECTCOLUMNS (

'Staffing Report',

"Manager", 'Staffing Report'[Level_9],

"NT_UserName", 'Staffing Report'[NT_Username],

"Level", "9"

),

SELECTCOLUMNS (

'Staffing Report',

"Manager", 'Staffing Report'[Level_10],

"NT_UserName", 'Staffing Report'[NT_Username],

"Level", "10"

),

SELECTCOLUMNS (

'Staffing Report',

"Manager", 'Staffing Report'[Level_11],

"NT_UserName", 'Staffing Report'[NT_Username],

"Level", "11"

),

SELECTCOLUMNS (

'Staffing Report',

"Manager", 'Staffing Report'[Level_12],

"NT_UserName", 'Staffing Report'[NT_Username],

"Level", "12"

)

)

I want to restrict to only if the manager value is not blank, then fetch the record on each level. How to achieve this?

Thanks

@GregR @Greg_Deckler @amitchandak 

[amitchandak · Accepted solution]

@Anonymous , On quick solution came to my mind is

Table = filter (Union(<Your code>), not(isblank([Manager])))

Or you need that as output from this table ?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

I am going to try this one first, looks like it will solve my issue. Thanks