Forum Discussion
DAX Measure
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
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 Fjoin col 2 with your Location and use col1, sum([value]) in the visual
2 Replies
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 Fjoin col 2 with your Location and use col1, sum([value]) in the visual
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.
