cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
twins2019 Frequent Visitor
Frequent Visitor

weighed dax

help me and sorry for my english!!

I have this situation in powerpivot

Customer Number Customer NameInv numberInvoice DateDue DateEurdsoISOStato
01003     aa010020792      20190211201903185,460GB Incassata
01003     aa1002079320190618201907186,7110GB Da incassare
GB00063   bb10020794201811062018110615,8595GB Incassata
GB00160   cc1002079520190606201908309,8615GB Da incassare
GB00160   cc10020796201905282019073112,733GB Da incassare
GB00213   dd10020797201806282018083115,7480GB Incassata
GB00213   dd10020798201806282018083116,1550GB Incassata
GB00213   dd10020799201810152018123116,4860GB Incassata
GB00213   dd10020800201901022019040116,4810GB Incassata
GB00213   dd10020801201809032018113018,7415GB Incassata
GB00231   cc10020802201903152019053120,112GB Incassata
GB00247   ee100208032018122420181224122GB Incassata
GB01276   ff1002080420190331201903315,2850GB 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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: weighed dax

Hello @twins2019 

 

Can you try :

 

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

View solution in original post

2 REPLIES 2

Re: weighed dax

Hello @twins2019 

 

Can you try :

 

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

View solution in original post

twins2019 Frequent Visitor
Frequent Visitor

Re: weighed dax

Ty very much

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

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

November 2019 Community Highlights

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

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)