Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
103 | |
68 | |
47 | |
39 | |
37 |