Forum Discussion
PietroFarias
Resolver II
7 years agoCalculating 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]) )
2 Replies
- LivioLanzo
Solution Sage
- PietroFarias
Resolver II
Great! It worked!!!