DAX Measure

[lavankumar1989a]

Hi All,

Hope all are doing great and safe!

Need assistance on creating a measure, i have a source table like below,

Location	Value
A	10
B	20
C	15
D	25
E	5
F	17
G	27

I am looking outcome like below,

Location	Value
A	10
B	20
C	15
D	25
E	5
F	17
G	27
BC	35
ADF	52

Which means need data like a source table and extra looking like in the end need to sum of both B and C and show as BC value and same as ADF as sum of A, D and F values.

So kindly suggest me with a right measure. Thanks in advance for your kind support.

Thanks,

Lavan

[amitchandak · Accepted solution]

@lavankumar1989a , You have to create a table like This

Col1 , Col2

A A
B B
C C
D D
E E
F F
G G
BC B
BC C
ADF A
ADF D
ADF F

join col 2 with your Location and use col1, sum([value]) in the visual

[lavankumar1989a]

@amitchandak , Thank you so much for your quick turn around. This currently i tried and it will give as expecting but i am looking is there a way to get the value by using Dax measure or column.