cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## weighed dax

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 ....

1 ACCEPTED SOLUTION
Post Patron

Hello @twins2019

Can you try :

Measure= SUMX(sheet1,sheet1[DSOl]*sheet1[EUR])/SUM(sheet1[EUR])

2 REPLIES 2
Post Patron

Hello @twins2019

Can you try :

Measure= SUMX(sheet1,sheet1[DSOl]*sheet1[EUR])/SUM(sheet1[EUR])

Frequent Visitor
Ty very much

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors