cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors