How to Get value to another Field

[bsbernabe]

Hello There,

The concern is about how to get the Age of the Data Type base on Account No.

I try to do that :

Only({<[Data Type] = {Repo}>} [Age]) but not working.

sample data source:

Account No.	Data Type	Age
123	ABC	30
456	EFG	40
789	ABC	5
910	HIJ	10
111	ABC	2

Should be output:

Age

30

5

2

Can you share with me how to do that?

Best Regards,

Bing

[Vegar · Accepted solution]

Why are you using Repo in Only({<[Data Type]={Repo}>}[Age]) ?

Try changing to 'ABC'.  Only({<[Data Type]={'ABC'}>}[Age])

When using Only then you need to make sure that you only get one value per dimension combination in your table. So in your example outpu you would ned to have Account No. as a dimension as well.