Use a measure with columns from Table A in Table B

[Anonymous]

I have the next tables:

Points
Business Area	Portfolio	Budget adjusted
A	1	90
B	1	189
C	1	360
…

Budget
Business Area	Portfolio	Budget	Budget Adjusted
A	1	100	90
A	2	200	180
B	1	210	189
B	2	300	270
C	1	400	360
C	2	500	450

Budget adjusted is a measure made in table Budget.

How can I use it in table POINTS to get the Budget Adjusted column as shown above?

I would like to keep it as a measure and not as a calculated column.

Thank you.

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Try this measure.

Measure = CALCULATE([Budget Adjusted],FILTER(Budget,Budget[Business Area]=SELECTEDVALUE(Points[Business Area])&&Budget[Portfolio]=SELECTEDVALUE(Points[Portfolio])))

Result would be shown as below.

Best Regards,

Jay

[Greg_Deckler]

@Anonymous - Use RELATED or RELATEDTABLE in your measure along with MAXX for example. Measures can live anywhere, it does not matter what their home table is.

[AllisonKennedy]

@Anonymous
I don't understand the full problem. Can you please provide more detail?

Measures do not belong to tables, so it does not matter where you see, store or created the measure, it can be used in a table visual with fields from any table as long as relationships exist and are setup correctly.

What is the DAX for the measure and what does the raw data look like? I don't understand the difference between the Points table and Budget tables?

[amitchandak]

@Anonymous , A new column Budget table

maxx(filter(Table, Points[Business Area] = Budget[Business Area] && Points[Portfolio] = Points[Portfolio] ),Points [Budget adjusted])

[Anonymous]

any alternative with a measure instead of a calculated column? @amitchandak 

Thank you very much.

[Anonymous]

any alternative with a measure instead of a calculated column?

Thank you very much.