cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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 Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,706)