cancel
Showing results for
Did you mean: Frequent Visitor

## AVG instead Total in matrix

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])

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

thanks

Regards!

1 ACCEPTED SOLUTION  Resolver III

Hello, @ivancornejo_
I tested new formula and get needed result.

AVG =
AVERAGEX (
SUMMARIZE ( FACT_SALES_ST; DIM_PRODUCT_ST[Product_division] );
"Net Value"; CALCULATE ( SUM ( FACT_SALES_ST[Net] ) )
);
[Net Value]
)

11 REPLIES 11  Resolver III

Hello!

Try this formula

AVG :=
AVERAGEX (
"Net Value"; CALCULATE ( SUM ( FACT_SALES_ST[Net] ) )
);
[Net Value]
) Frequent Visitor

Really close! @popov

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  Resolver III
Try it:
AVG :=
AVERAGEX (
"Net Value"; CALCULATE ( SUM ( FACT_SALES_ST[Net] ) )
);
[Net Value]
) Frequent Visitor

@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!  Resolver III

Could you share a sample file which can reproduce the issue? Frequent Visitor  Resolver III

Hello, @ivancornejo_
I tested new formula and get needed result.

AVG =
AVERAGEX (
SUMMARIZE ( FACT_SALES_ST; DIM_PRODUCT_ST[Product_division] );
"Net Value"; CALCULATE ( SUM ( FACT_SALES_ST[Net] ) )
);
[Net Value]
) Frequent Visitor

Hi @popov ,

I have used your formula, but I am still getting SUM instead of AVG.

Any ideas?

AVG =
AVERAGEX(
SUMMARIZE(product_per_store,'calendar'[Date].[Month]),"Net Value",[dayZ]),[Net Value]) Thanks!  Resolver III

You need to use column in table rows instead calendar'[Date].[Month]) Frequent Visitor

Fantastic @popov !

Thanks a lot 🙂  Post Patron

HI

can u share the link of sample PBIX file. I have same senario.

Thanks Announcements #### Welcome to the User Group Public Preview  