Comparisons between rates

[Anonymous]

I have a table that looks something like this

Customer	Cust Volume	supplier	weight	rate	iso
x	500	y	1	€       2,03	FRA
x	900	y	2	€       2,03	FRA
x	200	yz	2	€       2,65	ITA
xz	800	yz	5	€       5,41	USA
xz	1500	i	10	€       8,90	GBR

etc

I would like to make a comparison between two different supplier contracts that give rates based on the weight. Then once I make the difference between two sets of rates, I would like to multiply this by a customers real volume per weightbracket and iso to determine which supplier contract is more expensive. I am having trouble figuring out how to do this, since filtering in any way filters the other values as well. Any ideas?

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may try SUMX to add measures and take a look at this post.