Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Hi @Anonymous,
Could you try the formula below to see if it works in your scenario?
Total Calls = COUNTROWS ( ALL ( Click_SalesForms[LeadUID] ) )
Regards
Does each LeadUID have its own row in the table?
If so you can use something like
Total Calls = COUNTROWS(Click_SalesForms)
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |