Calculation by Rows in a Matrix

[Raitup00]

Hi everyone. I have the following problem with a matrix in Power BI: The original database is as shown in Image 1, applying "unpivot columns" I have reached image 2. The goal I want to achieve is that in the columns appears months, in the rows categories (Fcst and Inventory), but for Fcst calculates the sum per month and for Inventory calculates the average per month (image 3). By placing the values in the "Fields" section it only allows me to place either sum or average (image 4). The objective is to get a matrix that shows the calculations of image 5 in the same matrix. I hope you can guide me ...

[Raitup00]

Thanks AlexisOlson. That was the solution to my problem

[AlexisOlson · Accepted solution]

Define these calculations as separate explicit measures and use the "Show on rows" feature rather than use Atributo for the row headers.

If you pivot your data so that there are separate columns for separate metrics,

then you can still use implicit measures and choose your summarization.

Note: This still uses the "Values on rows".