Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |