Adding columns from visual table

[dtango9]

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 both distinct counts of dates.  Any help with the formula?

Thank you!

[amitchandak]

@dtango9 , No very clear. You need to provide the exact formula you need

You can create new measure

Distinct Date = calculate(distinctcount(Table[Date]))

New Measure = sum(Table[Phone Call]) + sum(Table[Appointments])

[dtango9]

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

[v-xicai]

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.