cancel
Showing results for
Did you mean:
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

Accepted Solutions
Member

## Re: weighed dax

Hello @twins2019

Can you try :

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

2 REPLIES 2
Member

## Re: weighed dax

Hello @twins2019

Can you try :

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

Frequent Visitor

## Re: weighed dax

Ty very much

Announcements

#### New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

#### November 2019 Community Highlights

Get an overview of the events and great community content from November.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)