Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Javif84
New Member

Agregation of Divide function

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

 

Javif84_0-1739479339036.png

 

https://we.tl/t-T0Zfe29nhN 

 

1 ACCEPTED SOLUTION
gmsamborn
Super User
Super User

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



Proud to be a Super User!

daxformatter.com makes life EASIER!

View solution in original post

2 REPLIES 2
Javif84
New Member

Thanks It works fine 🙂

gmsamborn
Super User
Super User

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



Proud to be a Super User!

daxformatter.com makes life EASIER!

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors