cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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])

2.- AVG = AVERAGEX(VALUES(FACT_SALES_ST[Business_type]); [S])

 

and the results are this, 

n1.png

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! 

 

 

 

 

11 REPLIES 11
Highlighted

@ivancornejo_ 

HI 

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

 

Thanks 

 

Highlighted

Hello, @dadadance,

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors