Forum Discussion

dtango9's avatar
dtango9
Helper II
6 years ago

Adding columns from visual table

Hello,   I'm looking to create a new column that I will add to an existing visual table on report view.  I'm looking to add 2 columns from that same visual table that I have made.  The columns are ...
Need Help
dtango9's avatar
dtango9
Helper II
6 years ago

I get this error when I created your new measure suggestion:

 

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi dtango9 ,

 

You may create relationship between the table phonecalls and appointments with "Both" Cross filter direction, then create measure like DAX below.

 

No. Connects = SUM ( phonecalls[actualend] ) + SUM ( appointments[scheduledend] )

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.