Dividing values from 2 matrix.. is it possible?

[Anonymous]

Hello gurus and this awesome community

I have two matrix set up on my power BI page... both of these come from their own slicers.. but slicer filters range is same for both tables.

I want to divide each corresponding pack size from matrix on the left to matrix on the right... is that even possible? 

trying to create a price premium/discount index

Tried searching for it, but being a new powerBI user, wasnt able to get much... 

thanks a ton!

[speedramps]

Sorry, we want to help but you explantion is poor. ☹️

None of the field names in your screen table, report and decsription corrsepond. 

it makes no sense at all ☹️

Please top rushing and write a clear description and you will get a quicker answer.

Provide some example input data (as tables not screen prints)

with  desired output and a clear description with consistent field names.

Remember not to share private data.

[Anonymous]

Please see my data table example below

I have a measure that calculates price per unit by Value Sales / Unit Sales 

I also have a standard calendar table with relationship to time column of this table below 

Now what I am trying to do is to calculate Manu 2 Brand 1 price per unit premium/discount (division) vs Manu 1 brand 1 - same pack size to same pack size (50 to 50)

Market	Manufacturer	Brand	Type	Type 2	Pack Size	Value Sales	Volume Sales	Unit Sales	Time
Germany	Manu 1	Brand 1	Black Coffee	Pods	50	100	200	10	Q1
Germany	Manu 1	Brand 2	Black Tea	Tea bags	65	120	22	65	Q1
Germany	Manu 2	Brand 1	Black Coffee	Pods	50	90	12	70	Q1

Currently I am showing two matrix on my BI page for both the brands with their respective packs next to each other (the image I pasted) now I want to divide the respective packs to understand the premium/discount

does it make sense now?

[speedramps]

You have not said what is onteh left and right table.

But lets say left contains the premiums and the right contains discount.

You need to create a star schema with a 

Calendar dimension (witt date and QQ YY period)

DimProduct (with ProductID and  pack size ) 

FactPremiums(with ProductID, date and premium ) 

FactDiscount (with ProductID, date and discount ) 

Then build a premium/discount measures and 1 matrix table suign the Calandar and DimProduct for the rows and columns.

The star relationships will then allow report premium/discount in matrix

Thanks for reaching out for help.

I have helped you, now please help me by giving kudos.

Remeber we are unpaid volunteers.

Click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each volnteer solver will get the kudos they deserve. Thank you !

[Anonymous]

Hi!

thanks for response

If I may clarify with more details

The table on the left is prices from 1 product and right is 2nd product, I want to divide the respective packs between product 1 and 2 to calcuate its discount/premium 

My current data structure is 2 tables as follows

my main table has all data in it... sales, regions etc... is it still possible to do the division?