Forum Discussion

afu's avatar
afu
New Member
7 years ago

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_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?

Need Help

1 Reply

  • RobbeVL's avatar
    RobbeVL
    Icon for Impactful Individual rankImpactful Individual
    7 years ago

    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