Forum Discussion
lavankumar1989a
5 years agoHelper II
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 ...
- 5 years ago
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
5 years agoSuper User
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
- lavankumar1989a5 years agoHelper II
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.