DAX measure to bring value from one side to many

[dicken]

To try this I just created a fact table ; sales id , customer , item , sales, and a dim ; customer , customer id,

and I want to bring the customer id to the sales fact table ; as a calculated column i did this two ways ,

MAXX( RELATEDTABLE(Customer),Customer[Id])

as the id is just number I used maxx but i don't think this is a very good way just the best i could think of.
and second ;

 LOOKUPVALUE( Customer[Id],Customer[Customer],Sales[Customer])

What I've been trying to do is write a measure to do the same, so I have a pivot with the sales id, sales, and I want a measur that would give me the
id from the customer table id.
if it helps i've put the file on onedrive.

MrX.xlsx

1drv.ms

Richard

 

[dicken]

I have since used the following

CALCULATE( MAXX(Customer, Customer[Id]),Sales)

which works, but im not sure if it's a good way and it still relies on MAXX and think there may be a better function to
bring back the value.

Richad.

 

[RoryA]

For a calculated column, I'd just use:

= RELATED(Customer[Id])

I can't conceive of why you would ever need it as a measure. It makes no sense.