Concatenate Summarize Columns

[SK87]

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.

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 :

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

KIndly suggest

[tamerj1]

@SK87 
If I correctly understand then create a calculated column

TableName[BrandA] & TableName[BrandB]

Then use it in the slicer

[SK87]

Thanks for your response, but unable to get the solution.

I basically want to create a combined slicer from Brand A & Brand

[tamerj1]

@SK87 
Also not sure if I correctly understand the requirement. However this is a sample file with the proposed solution https://we.tl/t-vZNbdEGPkU

First create a filter table:

Brands = 
SELECTCOLUMNS (
    DISTINCT ( 
        UNION (
            VALUES ( 'Dataset'[BrandA] ),
            VALUES ( 'Dataset'[BrandC] )
        )
    ),
    "Brand", [BrandA]
)

Create inactive relationships

Then create this filter measure and place it in the filter pane of the visual

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

[SK87]

I had written the first column measure as suggested and getting this error:

Brands = SELECTCOLUMNS(

                  DISTINCT(

                         UNION(

                                     VALUES(Data[Brand A]),

                                     VALUES(Data[Brand B]),

                                      VALUES(Data[Brand C]),

                                      VALUES(Data[Brand D])

                                  )

                               ),

                                "BRAND", [Brand A]

)

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]

@SK87 

This is a calculated table not a column

[SK87]

@tamerj1 

I created a calculated column and done as you suggested. Everything went well but the output I am looking is not there. 

I need a slicer in which only these 4 brands are there A, B,C, D and based on this I should get sub brands in the table.

See below screenshot, when I have selected brand as slicer where I have multiple brands but when I selected Brand A then in table I am only getting Brand A not other categories like BrandA.1, Brand A.2 etc same for others.

Also, in slicer if I keep new calculated column of Brand then I am getting numeric values instead of 4 major brand names

I wanted to see:

Hope this makes sense.

[tamerj1]

@SK87 

I think it is better to connect via teams or zoom. Let me know which time is convenient for you tomorrow.