Matrix Table with average

[harib]

Hello Friends,

I have 4 fields in Table format (ERI Returns, ERI Shipped, YRR Returns, YRR Shipped). I want to know the average of (ERI Returns and ERI Shipped) and (YRR Returns and YRR Shipped). I did unpivot, but values are not comming the way which i have expected like below image. I need a output like below image. How to achive like below image. Is it possible to show in Matrix. If anyone can do Pls send me sample file . My project stuck here.

Sample Data

https://drive.google.com/file/d/1brZTsnfqx0mTryREYkTrb5PreaC5mO8a/view?usp=sharing

Thanks in Advance

[v-yuta-msft]

@harib ,

You can unpivot the [ERI_RETURN_QTY], [ERI_SHIP_QTY], [YRR_RETURN_QTY] and [YRR_SHIP_QTY]. After close&applied, you can create a measure using DAX like pattern below:

Average = CALCULATE(AVERAGE(Sheet1[Value]), ALLEXCEPT(Sheet1, Sheet1[Category]))

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[harib]

@v-yuta-msft 

Hi

Why all year average values are same. I didn't understand the concept.A s shown in picture i need average between 1. ERI Returns, ERI Shipped 

2. YRR Returns, YRR Shipped

Could u please explain .

Thanks

---

@v-yuta-msft wrote:

@harib ,

You can unpivot the [ERI_RETURN_QTY], [ERI_SHIP_QTY], [YRR_RETURN_QTY] and [YRR_SHIP_QTY]. After close&applied, you can create a measure using DAX like pattern below:

Average = CALCULATE(AVERAGE(Sheet1[Value]), ALLEXCEPT(Sheet1, Sheet1[Category]))

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

---