division in a matrix

[Shackwell]

Hello there.

I am trying to divide the results on 2 matrices within my power bi report.

First Matrix is like this

                TOTAL SALES 2018,    TOTAL SALES 2019 , TOTAL SALES 2020

ZONE 01
ZONE 02
ZONE 03

Second Matrix is

               UNITS SOLD 2018, UNITS SOLD 2019, UNITS SOLD 2020

ZONE 01
ZONE 02

ZONE 03

And the third matrix would like to be the operations. Where I could divide total units sold so i can get a weighted price average. I am going to be working with a few matrices and this one would be great to understand. Thank you for your time.

[parry2k]

Raw data that you are brining into Power BI without any transformation.

[Shackwell]

 here is a small sample. I am using "bridge" connections to link the databases. In this case I inserted ZONE on the PBI catalog manually. And I have also a list of all the ITEMS to be sold. So I created a matrix between these 2 "bridges" and then im filling such matrices with the information I imported from excel. I am not sure if Im being clear with this or do I need a further clarification. Thank you for your time.

[Shackwell]

Let me show you the arrange of my data. Just give me a little bit info here, do you want to see the data from the excel spread sheet or the one that is integrated on the Power BI?

[parry2k]

@Shackwell Based on your reply, it looks like your data is not in the shape where you can achieve this desired result. To clarify this, it will be easier if you paste some raw sample data, and take a moment to read the link I provided to avoid unnecessary back and forth. 

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 

[Shackwell]

Hello. Unit solds and sales amount are both in 1 column each from the database that is in the year 2018. There no need to create a measure as it is already on the database. The thing is I am using several databases (they are yearly bases) and I am trying to look for the average unit price, as my units have different price according to the month in motion. 

[parry2k]

@Shackwell the formula is pretty straightforward but could you provide the details on where the units sold and sales amount are coming from? Are they in a single table or different tables? Are you using measures to show these values? 

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490