Forum Discussion
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('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
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.
1 Reply
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.