Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |