Forum Discussion

aaldo_666's avatar
aaldo_666
Icon for Helper I rankHelper I
3 years ago

CONCATENATEX not working with relationship

I have simple model with one:many relationship on column Invoice No. table one = sql server directquery table many = sharepoint list All I need is fill selected invoice numbers into variable var_c...
Need Help
  • aaldo_666's avatar
    aaldo_666
    Icon for Helper I rankHelper I
    3 years ago

    Yes, there is one row in MANY table - see DateSent column with date. When there is matching row, DAX expression works fine, but when there is no mathing row expression is blank. 

    But all columns in the table are from ONE table and only DateSent is from MANY tables. I dont understand why that should matter for DAX.

    • aaldo_666's avatar
      aaldo_666
      Icon for Helper I rankHelper I
      3 years ago

      I tested that model with import mode and DAX works fine there. So it looks like problem is with DAX in  DirectQuery mode when there is no matching row in MANY table.