Table.AggregateTableColumn return 1 even if there is no data (Dynamics CRM Odata source)

[vcb]

Using this expression in a Dynamics CRM odata extraction of the CRM entity "leads"

#"Aggregated Lead_Emails" = Table.AggregateTableColumn(#"Aggregated Lead_Phonecalls", "Lead_Emails", {{"activityid", List.Count, "Count of Lead_Emails.activityid"}}),

The count return the good value if there is data but if in that case there is no email the function return 1.

I can observe this behavior for all other relation attributes

[v-qiuyu-msft]

Hi @vcb,

Would you please clarify this "The count return the good value if there is data but if in that case there is no email the function return 1."? It would be better if you could share some screenshots to clarify the issue. 

Best Regards,
Qiuyun Yu