Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have to do the average in the "delivery cost column", without sum the quantity.
For example. where in "n° extra shipping" column there is "0" i want to have an average like 0€
where there is 1, 5€ and where there is 2 , 10€. Even if filter for "means of delivery" or date.
I hope i was clear.
Could you please help me?
Thank you
N° Extra shipping | Means of delivery | delivery cost € |
0 | CAMION | - € |
0 | CAMION | - € |
0 | CAMION | - € |
1 | FURGONE1 | 5,00 € |
1 | FURGONE1 | 5,00 € |
1 | FURGONE1 | 5,00 € |
2 | FURGONE2 | 10,00 € |
2 | FURGONE2 | 10,00 € |
Solved! Go to Solution.
Hey,
try a measure like this
an average = AVERAGEX( VALUES('table'[N° Extra Shipping] ,CALCULATE(AVERAGE('table'[delivery cost]) )
Hopefully this will provide what you are looking for.
Regards,
Tom
Hey,
try a measure like this
an average = AVERAGEX( VALUES('table'[N° Extra Shipping] ,CALCULATE(AVERAGE('table'[delivery cost]) )
Hopefully this will provide what you are looking for.
Regards,
Tom
ok, i have correct the formula, but it isnt what i have to do.
My result it should be:
A=10€
A=10€
A=10€
TOTAL= 10€
B=5€
B=5€
B=5€
TOTAL=5€
GRAND TOTAL= 15€
Now my resul is 10+10+10+5+5+5 =45€ (with the formula like a coloumn)
and 10+10+10=30 5+5+5=15 /2 =22.5 (with the formula like a measure)
Thank you for our answer.
But im facing this problem. It dont me let add "calculate". What is the problem?
"N° trasporti extra" is "N° extra shippping", and "costo trasporto" is "delivery cost"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |