Want to remove Blank results from a DISTINCT DAX

[Anonymous]

Hello,

I'd be grateful if someone'd shed some light here:

When I use measure then I get a row with a Blank value:

Team Table =

DISTINCT (

UNION (

SELECTCOLUMNS ( DIA_SAP_ABSENZEN, "Team", DIA_SAP_ABSENZEN[Team] ),

VALUES ( DIA_SAP_FERIENSOLL[Team] )

)

)

How can remove the Blank from the results?

[amitchandak · Accepted solution]

@Anonymous , Try like

DISTINCT (filter(
UNION (
SELECTCOLUMNS ( DIA_SAP_ABSENZEN, "Team", DIA_SAP_ABSENZEN[Team] ),
VALUES ( DIA_SAP_FERIENSOLL[Team] )
),not(isblank(Team))
) )

[Anonymous]

Hi @amitchandak 

Thank you very much for your response and suggestion!

This is how I applied it, and it works:

Team Table =

DISTINCT (FILTER(

UNION (

SELECTCOLUMNS ( DIA_SAP_ABSENZEN, "Team", DIA_SAP_ABSENZEN[Team] ),

VALUES ( DIA_SAP_FERIENSOLL[Team] )

),NOT(ISBLANK([Team])

)))

Now, there are no longer Blanks in the table. However, when I use Team in a Slicer, then I can still see Blank as value. I'm worried that this might impact my visuals in a way that I'm not aware of (even if I filter out Blank from the slicer).

Do you think it's ok as it is?