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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |