Forum Discussion

Javif84's avatar
Javif84
New Member
1 year ago
Solved

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

 

 

https://we.tl/t-T0Zfe29nhN 

 

Need Help

2 Replies

  • gmsamborn's avatar
    gmsamborn
    Icon for Super User rankSuper User
    1 year ago

    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