Forum Discussion

PietroFarias's avatar
PietroFarias
Icon for Resolver II rankResolver II
7 years ago
Solved

Calculating measures by filtering column with values from another column

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])
)