Post reply

DAX Related() Function Issue

  • December 20, 2016 at 7:15 am

    #149221

    I have a fact table and a bunch of dimension tables. There are foreign keys in the database between the fact table and all dimension tables. These relationships are present in the SSAS tabular model. However, if I try to create a calculated column in the fact table using the related function I get no intelisense. If I type the fully qualified column name in the related function it adds the column and the data in the column is correct, but in the function window the table/column name is underlined red.

    Any idea why this is happening? I've been searching buy haven't found a solution to this.

    Thanks!

  • December 20, 2016 at 10:46 am

    #1918981

    I'm starting to think this is a Visual Studio bug. I'm finding more bugs with VS 2015 than I can count.

    I thought it may have been something I was doing. Using VS 2015 update 3 I imported the FactInternetSales and related tables into a tabular model. The Related() function still did not work. I opened VS 2010 and did the exact same thing, it works fine.

  • January 26, 2017 at 11:33 am

    #1925138

    cboneill181 - Tuesday, December 20, 2016 10:46 AM

    I'm starting to think this is a Visual Studio bug. I'm finding more bugs with VS 2015 than I can count.I thought it may have been something I was doing. Using VS 2015 update 3 I imported the FactInternetSales and related tables into a tabular model. The Related() function still did not work. I opened VS 2010 and did the exact same thing, it works fine.

    Just in case anyone else has this issue.  I opened up a case with Microsoft about this and supposedly it's fixed in the upcoming release of SSDT.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply