Looking up a single value based on three filters

[MrBrodya]

Hi Everybody,

I am having trouble making the formula work for looking up a single exchange rate value based on three filters with the enclosed table.

Currency      Year       Version            Type        Month ExchRate MonthID

USD/JPY	151P	CURRENT	GL_AVGRATE	APR	105	151PAPR
USD/JPY	151P	CURRENT	GL_AVGRATE	MAY	105	151PMAY
USD/JPY	151P	CURRENT	GL_AVGRATE	JUN	105	151PJUN
USD/JPY	151P	CURRENT	GL_AVGRATE	JUL	105	151PJUL
USD/JPY	151P	CURRENT	GL_AVGRATE	AUG	105	151PAUG
USD/JPY	151P	CURRENT	GL_AVGRATE	SEP	105	151PSEP
USD/JPY	151P	CURRENT	GL_AVGRATE	OCT	105	151POCT
USD/JPY	151P	CURRENT	GL_AVGRATE	NOV	105	151PNOV
USD/JPY	151P	CURRENT	GL_AVGRATE	DEC	105	151PDEC
USD/JPY	151P	CURRENT	GL_AVGRATE	JAN	105	151PJAN
USD/JPY	151P	CURRENT	GL_AVGRATE	FEB	105	151PFEB
USD/JPY	151P	CURRENT	GL_AVGRATE	MAR	105	151PMAR

My formula is as follows:

CALCULATE(sum(Curr_Rate[ExchRate]),Filter(Curr_Rate,Curr_Rate[Version]="CURRENT" && Curr_Rate[MonthID]="151PSEP" && Curr_Rate[Currency]="USD/JPY"))

Any assiatance would be appreciated.

[Anonymous · Accepted solution]

works fine for me. see attached. change source value for 151PSEP and it'll reflect in the measure

https://ufile.io/poar1

[MrBrodya]

chirayuw thank you!

[Stachu]

the syntax you posted is correct, as long as the combination of these 3 columns returns only 1 row - is that the case? or does the measure not work as intended?
or do you want this to be dynamic based on the slicer selection rather than hardcoded?