October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
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
Solved! Go to 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 , 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
@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.
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |