Forum Discussion

lavankumar1989a's avatar
5 years ago
Solved

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 ...
  • amitchandak's avatar
    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 F

     

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