How to add the values of a measure and a column for a visual?

[Anonymous]

Okay, so basically I'm trying to make a very basic roundabout way of write back.

I have two tables.

tRaw which contains a lot of info but the two that matter are are ZIP codes and Delivery Cost.

ZIP Code		Delivery Cost
12345		$10
23456		$15
34567		$10
45678		$20
56789		$15

And 'Table' which is a table ranging from 0-9

0
1
2
3
4
5
6
7
8
9

I also have another table called 'Pricing' that has a column called 'Column1' that just referencing 'Table'

I have also created a measure in 'Pricing' that references said Table called 'Measure' = SELECTEDVALUE('Pricing'[Column1])

Picture for reference since the names got kind of confusing. I promise I'll change them for the final product lol

Back to tRaw, I have created a measure amplty called 'Measure 2' as a test

Measure 2 = SELECTEDVALUE('Pricing'[Column1]) + 1

The aim of this, is that now I have a visual that loooks like this

and another Table Visual that lookes like this

ZIP Code		Delivery Cost		Measure 2
12345		$10		1
23456		$15		1
34567		$10		1
45678		$20		1
56789		$15		1

If on the first visual, I were to select the number 3, the visual would update to this as a proof of concept

ZIP Code		Delivery Cost		Measure 2
12345		$10		4
23456		$15		4
34567		$10		4
45678		$20		4
56789		$15		4

This example, works in Power BI. That's all good.

What I need help with and is my main goal, is to have the visual work like this

A) I select a value from the Column1 visual, 3 again for this example

B) The second visual would update to look like this

ZIP Code		Delivery Cost		Measure 2
12345		$10		13
23456		$15		18
34567		$10		13
45678		$20		23
56789		$15		18

I feel like I'm so close. I'm not sure what to type in DAX for the measure for it to be able to add the selected value of Column1 and 'Delivery Cost'. I just want to get from point A to point B

Please and thank you

[johnt75]

You can create the measure as

Measure 2 = SELECTEDVALUE( tRaw[Delivery Cost]) + SELECTEDVALUE('Table'[Column1])

[Ashish_Mathur]

Hi,

Assuming Delivery cost is a measure, write this measure

Measure = [Delivery cost]+[measure 2]

[Anonymous]

So Delivery Cost is a column that is on a different table called tMaster. That value is imported directly from an excel file sitting on a shared drive. I created another column in tRaw called 'Delivery Cost' to try to see if the measure could pull from it but it can't.

Any more suggestions?

[Anonymous]

Delivery Cost is a column, but I'm pretty sure I can make it a measure. I'll get back to ya if it works!