Summarize

[Anonymous]

Please Advice. I Have a Table. I need to summarize and also do a count.

Column A - Campaign Name 

Column B - Sent (Codes)

Column C - Opens (Codes)

Need to summarize by Campaign Names and get Count of Sent & Opens

[amitchandak · Accepted solution]

@Anonymous , Try like

Measure 3= divide( count(Table[Opens (Codes)]),count(Table[Sent (Codes)]) )

[amitchandak]

@Anonymous , put in visual Campaign Name as unsummarized or axis or row

can use count in visual or measures like these

Measure 1= count(Table[Sent (Codes)])

measure 2= count(Table[Opens (Codes)])

[Anonymous]

Thanks @amitchandak 

I am new to this. I also need to calculate Open Rate from the counts. (Count of opens / Count of Sent). Not able to create a calculated value in the Matrix Visual.