Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi all
Please could you help?
I have a simple function that get Touchpoint Universe by Dividing "Penetration Active Users" by "% Penetration (over Total Customers but I would like to aggregate it to get 14+27+60 as Total instead of 14
Sharing the Sample
Thanks a million
Solved! Go to Solution.
Hi @Javif84
Would a measure like this help?
TOUCHPOINT UNIVERSE KPIS =
SUMX(
'KPI TARGETS',
DIVIDE(
[Penetration Active Users],
[% Penetration (over Total Customers)]
)
)
Let me know if you have any questions.
Aggregation of DIVIDE function.pbix
Thanks It works fine 🙂
Hi @Javif84
Would a measure like this help?
TOUCHPOINT UNIVERSE KPIS =
SUMX(
'KPI TARGETS',
DIVIDE(
[Penetration Active Users],
[% Penetration (over Total Customers)]
)
)
Let me know if you have any questions.
Aggregation of DIVIDE function.pbix
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 104 | |
| 82 | |
| 72 | |
| 46 | |
| 35 |