0

Im using SSAS Tabular. Trying to insert a column which gets data(OrgNumber) from an unrelated table called DimCustomer.

DAX-Syntax:

=Calculate(Values('DimCustomer'[OrgNum]),FILTER('DimCustomer','DimCustomer'[CustomerNr]='FactTransactions'[CustomerNr])))

Throws back error msg:

The syntax for 'FILTER' is incorrect. The calculated column 'FactTransactions[CalculatedColumn1]' contains a syntax error. Provide a valid formula.

Blixter
  • 338
  • 4
  • 12
  • Hi @Blixter if any answer has solved your question please consider [accepting it](http://meta.stackexchange.com/q/5234/179419) by clicking the check-mark. This indicates to the wider community that you've found a solution and gives some reputation to both the answerer and yourself. There is no obligation to do this. – GregGalloway Aug 13 '15 at 08:54

2 Answers2

1

Try this:

=LOOKUPVALUE('DimCustomer'[OrgNum], 'DimCustomer'[CustomerNr], 'FactTransactions'[CustomerNr])

This assumes it is a calculated column on FactTransactions

GregGalloway
  • 11,355
  • 3
  • 16
  • 47
0

I laid out your code like the below and it seems you have an extra bracket:

=Calculate
(
    Values('DimCustomer'[OrgNum]),
    FILTER
    (
        'DimCustomer',
        'DimCustomer'[CustomerNr]='FactTransactions'[CustomerNr]
    )
)
)
MyLittleDax
  • 21
  • 1