Remove empty Summarize

[cristianml]

hi,

I want to remove or not consider empty values when  I create a table with summarize:

_List Industry Segment =

VAR V1 = SUMMARIZE('Rev CCI','Rev CCI'[Industry Segment])

VAR V2 = SUMMARIZE('CI',CI[Industry Segment])

VAR V3 = SUMMARIZE(Attribute,Attribute[Industry Segment])

VAR V4 = SUMMARIZE(DSO,DSO[Industry Segment])

RETURN

(DISTINCT(UNION(V1,V2,V3,V4)))

How can I avoid this ?

thanks

[v-jianboli-msft · Accepted solution]

Hi @cristianml ,

Please try:

_List Industry Segment =
VAR V1 =
    SUMMARIZE ( 'Rev CCI', 'Rev CCI'[Industry Segment] )
VAR V2 =
    SUMMARIZE ( 'CI', CI[Industry Segment] )
VAR V3 =
    SUMMARIZE ( Attribute, Attribute[Industry Segment] )
VAR V4 =
    SUMMARIZE ( DSO, DSO[Industry Segment] )
VAR V5 =
    ( DISTINCT ( UNION ( V1, V2, V3, V4 ) ) )
RETURN
    FILTER ( V5, [Industry Segment] <> BLANK () )

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.