Calculating measures by filtering column with values from another column

[PietroFarias]

Hey guys.

I've the next syntax as a measure. That return me the result from measure [QtdTrans] where [CustomerID] contains in LstCustomerAct[CustomerID]. Simple. But, i'm having problems with some Excel 2013 users. The error is 'IN'.

How can i substitute 'IN' to the other syntax that can read in PowerPivot 2013 without error?

QtdTrans_AF:=
CALCULATE(
	[QtdTrans];
	[CustomerID] IN VALUES(LstCustomerAct[CustomerID])
)

[LivioLanzo · Accepted solution]

Hello @PietroFarias

you can use CONTAINS for older versions of DAX: https://dax.guide/contains/

[PietroFarias]

Great! It worked!!!