Forum Discussion

meIdo's avatar
meIdo
Helper I
3 years ago

Is there a way??

Hi guys,

I am trying to add 2 or more than 2 columns. I used SUMX function to add all values.  Now, I would like to have Total value as Y axis and Columns in X axis. Is it even possible? I have created below but the bars are showing same, I created a new table with column names and just added. I don't know how to link two tables and on what basis

Thanks 

 

Note I have attached a pictures

Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi meIdo 

     

    It seems your amounts are from different columns, you can add your new table's [column name] on x-axis, then try the following measure for y-axis. 

    Total Measure =
SWITCH (
    'new table'[column name],
    "Script", SUM ( 'table'[item_Script_Amount] ),
    "Script Con", SUM ( 'table'[item_Script_Con_Amount] ),
    "Other", SUM ( 'table'[item_Other_Amount] )
)

     

    You can add many value & result pairs in SWITCH function. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.