Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
3 years ago
Solved

Remove empty Summarize

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('C...
Data Protection
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

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.