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 all,
I need know if I can change the Total Value for AVG, but in the same column that totals are showing.
I've try with these formula
1.- S = SUM(FACT_SALES_ST[Net])
2.- AVG = AVERAGEX(VALUES(FACT_SALES_ST[Business_type]); [S])
and the results are this,
So, i.e, in the second column, AVG, I have
2.189.255
5.800.164
17.143.370
25.132.789
same value for Net. well, that is incorrect, AVG for those values is 8.377.596,3
So, I need the value 8.377.596,3 (AVG) in the same column that Total
avg instead total..
thanks
Regards!
Solved! Go to Solution.
Hello, @ivancornejo_
I tested new formula and get needed result.
AVG =
AVERAGEX (
ADDCOLUMNS (
SUMMARIZE ( FACT_SALES_ST; DIM_PRODUCT_ST[Product_division] );
"Net Value"; CALCULATE ( SUM ( FACT_SALES_ST[Net] ) )
);
[Net Value]
)
Hello!
Try this formula
AVG :=
AVERAGEX (
ADDCOLUMNS (
SUMMARIZE ( FACT_SALES_ST; FACT_SALES_ST[Business_type] );
"Net Value"; CALCULATE ( SUM ( FACT_SALES_ST[Net] ) )
);
[Net Value]
)
Really close! @popov
thanks for quick answer
with your formual I get this. I have AVG but for row Total.
so, basically, need this
In "blue" row, I need the AVG, for each column
Hope you understand
@popov, Thanks a lot!
It looks fantastic!
but (sorry), now have this
columns MKTG, RETAIL AND WHOLESALE are good, but Total Column show AVG for each row (accesories, apparel and footwear)
you can see de differences with this, in Total column is a SUM and Total row is the AVG
Thanks again!
Could you share a sample file which can reproduce the issue?
Hello, @ivancornejo_
I tested new formula and get needed result.
AVG =
AVERAGEX (
ADDCOLUMNS (
SUMMARIZE ( FACT_SALES_ST; DIM_PRODUCT_ST[Product_division] );
"Net Value"; CALCULATE ( SUM ( FACT_SALES_ST[Net] ) )
);
[Net Value]
)
Hi @popov ,
I have used your formula, but I am still getting SUM instead of AVG.
Any ideas?
Hello, @Anonymous,
You need to use column in table rows instead calendar'[Date].[Month])
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |