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
help me and sorry for my english!!
I have this situation in powerpivot
| Customer Number | Customer Name | Inv number | Invoice Date | Due Date | Eur | dso | ISO | Stato |
| 01003 | aa | 010020792 | 20190211 | 20190318 | 5,4 | 60 | GB | Incassata |
| 01003 | aa | 10020793 | 20190618 | 20190718 | 6,71 | 10 | GB | Da incassare |
| GB00063 | bb | 10020794 | 20181106 | 20181106 | 15,85 | 95 | GB | Incassata |
| GB00160 | cc | 10020795 | 20190606 | 20190830 | 9,86 | 15 | GB | Da incassare |
| GB00160 | cc | 10020796 | 20190528 | 20190731 | 12,73 | 3 | GB | Da incassare |
| GB00213 | dd | 10020797 | 20180628 | 20180831 | 15,74 | 80 | GB | Incassata |
| GB00213 | dd | 10020798 | 20180628 | 20180831 | 16,15 | 50 | GB | Incassata |
| GB00213 | dd | 10020799 | 20181015 | 20181231 | 16,48 | 60 | GB | Incassata |
| GB00213 | dd | 10020800 | 20190102 | 20190401 | 16,48 | 10 | GB | Incassata |
| GB00213 | dd | 10020801 | 20180903 | 20181130 | 18,74 | 15 | GB | Incassata |
| GB00231 | cc | 10020802 | 20190315 | 20190531 | 20,11 | 2 | GB | Incassata |
| GB00247 | ee | 10020803 | 20181224 | 20181224 | 12 | 2 | GB | Incassata |
| GB01276 | ff | 10020804 | 20190331 | 20190331 | 5,28 | 50 | GB | Incassata |
I need a MESURE that make DSO*EUR and divide it by the total turnover EUR of each individual customer:
I have tried different formulas but it always divides me for the total of ALL customers and not for a single customer ....
help me please
Solved! Go to Solution.
Hello @Anonymous
Can you try :
Measure= SUMX(sheet1,sheet1[DSOl]*sheet1[EUR])/SUM(sheet1[EUR])
Hello @Anonymous
Can you try :
Measure= SUMX(sheet1,sheet1[DSOl]*sheet1[EUR])/SUM(sheet1[EUR])
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!