Single value from multiple rows

[Irek]

Snapshot date	Id	BU	FTE	allocation	key
01.01.2022	1	a	1		snaphsot plus id
01.01.2022	1	b	1
01.01.2022	2	a	0.5
01.01.2022	2	b	0.5
01.02.2022	1	1	1

Hi, these one is probably the easiest one ever but can't figure it out. 

I need to get FTE value for each ID, no matter how many BU they they have. result shoud be ID 1 FTE = 1, id 2 FTE = 0.5 

Thank you in advance 

MA

[MFelix · Accepted solution]

Hi @Irek ,

You can try to make the MAX or MIN of the value for each FTE. Is the data you present your fact table?

[Irek]

HI @MFelix , 

Max will be fine but how force calculation to use snapshot as a filter?

I have anothet table where Id's are duplicated , same for FTE , tried lookup but failed 🙂

[MFelix]

Hello @Irek ,

Are you abble to provide a sample file?

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.