Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Calculate Totals Using Count

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?

2 Replies

  • aoberlander's avatar
    aoberlander
    Frequent Visitor
    9 years ago

    Does each LeadUID have its own row in the table?

    If so you can use something like

    Total Calls = COUNTROWS(Click_SalesForms)

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

     

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

     

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

     

    Regards