Calculate Totals Using Count

[Anonymous]

Hi! 

I am attempting to create a contact rate report. Ive ran into a problem when trying to count the number of total call leads. 

There are over a million rows, but my measure results are getting small numbers. 

This is my measure: 

 Total Calls = COUNT(Click_SalesForms[LeadUID])

>> Im getting "1", which I know is incorrect. 

Any help?

[v-ljerr-msft]

Hi @Anonymous,

Could you try the formula below to see if it works in your scenario? 

Total Calls = COUNTROWS ( ALL ( Click_SalesForms[LeadUID] ) )

Regards

[aoberlander]

Does each LeadUID have its own row in the table?

If so you can use something like

Total Calls = COUNTROWS(Click_SalesForms)