Forum Discussion
Alternatives to SUM Distinct Counts
receipient_open_sum = var t=SUMMARIZE(z_hubspot_email_final,z_hubspot_email_final[campaign_id],"recipient_open",CALCULATE((COUNT(z_hubspot_email_final[recipient])),FILTER(z_hubspot_email_final,z_hubs...
RobbeVL
Impactful Individual
Impactful IndividualIf your dataset allows it, you could do these aggregations in Powerquery.
This will precalculate everything before loading it to your dataset, so improve your performance on that.
Ofcourse this might goes at the cost of losing other relationships