Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
twins2019
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
AndrejZitnay
Post Patron
Post Patron

Hello @twins2019 

 

Can you try :

 

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

View solution in original post

2 REPLIES 2
AndrejZitnay
Post Patron
Post Patron

Hello @twins2019 

 

Can you try :

 

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

Ty very much

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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