Alternatives to SUM Distinct Counts

[afu]

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_hubspot_email_final[type]="OPEN"))) return SUMX(t,[recipient_open])

This runs really slow. I've searched for alternatives, but have not had much luck.

Any suggestions?

[RobbeVL]

If 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