Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet 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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.