Concatenate Summarize Columns

Question

Hi Team,I have 2 columns as "Whole Number" in which have value from 0-10. Name column name as A, C. I need to prepare one measure/column which will act as a slicer of all these 2 columns as 1. Based on this the selection of other brands would be done and their respective values would be shown.&nbsp;A brand columns contains suppose 5 sub brands and same with C but sub brands could be different.How I can combine these 2 columns into one or make any measure which acts in same way.Dataset :BrandValuesBrandABrandCN70.205N70.200N74.105N74.100N70.205N70.200N67.605N67.600C66.301C66.300C88.401C88.400C98.801C98.800C83.201C83.200C13001C13000C122.201C122.200C92.301C92.300C93.601C93.600C83.201C83.200C59.801CG7.802CG9.102CG11.702CG11.702CG11.702CG10.402CG16.902CG14.302CG14.302CG1302CG16.902CG23.402CG24.702CG27.302CG2602CG27.302CG3902CG44.202CG37.702CG31.202A41.610A41.610A42.910A42.910A37.710A44.210AD71.520AD7820AD76.720AD67.620AD74.120CO57.230CO57.230CO58.530N9140N92.340N92.340P106.650P102.750P97.550P94.950P96.250P89.750P98.850P93.650R96.260R79.360R80.660R81.960R81.960KIndly suggest

tamerj1 · Answer

SK87&nbsp;If I correctly understand then create a calculated columnTableName[BrandA] &amp;&nbsp;TableName[BrandB]Then use it in the slicer

sk87 · Answer

Thanks for your response, but unable to get the solution.I basically want to create a combined slicer from Brand A &amp; Brand

tamerj1 · Answer

SK87&nbsp;Also not sure if I correctly understand the requirement. However this is a sample file with the proposed solution&nbsp;https://we.tl/t-vZNbdEGPkUFirst create a filter table:&nbsp;Brands = 
SELECTCOLUMNS (
    DISTINCT ( 
        UNION (
            VALUES ( 'Dataset'[BrandA] ),
            VALUES ( 'Dataset'[BrandC] )
        )
    ),
    "Brand", [BrandA]
)Create inactive relationships&nbsp;Then create this filter measure and place it in the filter pane of the visual&nbsp;Total Value = 
VAR BrandAValue =
    CALCULATE (
        SUM ( 'Dataset'[Values] ),
        USERELATIONSHIP ( 'Dataset'[BrandA], 'Brands'[Brand] )
    )
VAR BrandCValue =
    CALCULATE (
        SUM ( 'Dataset'[Values] ),
        USERELATIONSHIP ( 'Dataset'[BrandC], 'Brands'[Brand] )
    )
RETURN
    BrandAValue + BrandCValue&nbsp;

sk87 · Answer

I had written the first column measure as suggested and getting this error:&nbsp;Brands = SELECTCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DISTINCT(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;UNION(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VALUES(Data[Brand A]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VALUES(Data[Brand B]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES(Data[Brand C]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES(Data[Brand D])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "BRAND", [Brand A])&nbsp;ERROR: "A table of multiple values was supplied where a single value was expected."I want Brand A, Brand B, Brand C, Brand D in slicer instead of numbers i.e. 0-6

tamerj1 · Answer

SK87&nbsp;This is a calculated table not a column

Forum Discussion

Concatenate Summarize Columns

7 Replies

Related content

Concatenate 3 columns

create custom column concatenated

add concatenated column to summarize table

Power query - concatenate text columns

Parameter in summarize

Brand	Values	BrandA	BrandC
N	70.2	0	5
N	70.2	0	0
N	74.1	0	5
N	74.1	0	0
N	70.2	0	5
N	70.2	0	0
N	67.6	0	5
N	67.6	0	0
C	66.3	0	1
C	66.3	0	0
C	88.4	0	1
C	88.4	0	0
C	98.8	0	1
C	98.8	0	0
C	83.2	0	1
C	83.2	0	0
C	130	0	1
C	130	0	0
C	122.2	0	1
C	122.2	0	0
C	92.3	0	1
C	92.3	0	0
C	93.6	0	1
C	93.6	0	0
C	83.2	0	1
C	83.2	0	0
C	59.8	0	1
CG	7.8	0	2
CG	9.1	0	2
CG	11.7	0	2
CG	11.7	0	2
CG	11.7	0	2
CG	10.4	0	2
CG	16.9	0	2
CG	14.3	0	2
CG	14.3	0	2
CG	13	0	2
CG	16.9	0	2
CG	23.4	0	2
CG	24.7	0	2
CG	27.3	0	2
CG	26	0	2
CG	27.3	0	2
CG	39	0	2
CG	44.2	0	2
CG	37.7	0	2
CG	31.2	0	2
A	41.6	1	0
A	41.6	1	0
A	42.9	1	0
A	42.9	1	0
A	37.7	1	0
A	44.2	1	0
AD	71.5	2	0
AD	78	2	0
AD	76.7	2	0
AD	67.6	2	0
AD	74.1	2	0
CO	57.2	3	0
CO	57.2	3	0
CO	58.5	3	0
N	91	4	0
N	92.3	4	0
N	92.3	4	0
P	106.6	5	0
P	102.7	5	0
P	97.5	5	0
P	94.9	5	0
P	96.2	5	0
P	89.7	5	0
P	98.8	5	0
P	93.6	5	0
R	96.2	6	0
R	79.3	6	0
R	80.6	6	0
R	81.9	6	0
R	81.9	6	0