Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculated column across multiple tables

Hello, I have a database with quite a few tables in it and I need to be able to calculate a combined volume of items. Now the tricky part is there are so many link I can't quite work out what to do (I'm a bit of a noob)

 

I will write this a bit like a query so it will say tablename(column) and I have given an example of the numbers involved below.

 

  • diary(ddid) which has a unique reference links to claimentity(credid) via the same reference and can give many results.
    • So diary(DDID) 490841 returns 11 items in claimentity(credid) each with unique claimentitiy(custid)

 

  • If we then take the top item in the screenshot above, claimentity(custid) 2100600 links to reminvent(riid). Then we take the value of reminvent(ri-packmethod) which is also unique 1424908P

 

  • We want to link reminvent(ri-packmethod) to inventory(in-number) on 1424908P for example but Power BI crashes when trying to create a link between these tables (any idea why this is?)
  • We would like to return inventory(in-nm) for the volume of 1424908P.

     

     

     

    Thanks in advance  

     

     

     

     

     

 

 

 

 

 

 

 

 

Need Help
  • tonijj's avatar
    tonijj
    8 years ago

    Nah, this is a known error in the december release of BI desktop. It was fixed in January release. So download the latest version and that particular issue is solved. Had the same thing.

6 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    You said Power BI crashes when you link reminvent(ri-packmethod) to inventory(in-number) on 1424908P. How it crash, what error message you got?

    How do you get 0.192, which come a column of another table?

    Best Regards,
    Angelia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Morning, a black box comes up with SQLdumper as below

       

       

       

      In the event log there are 2 messages

       

       

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        8 years ago

        Hi Anonymous,

        From your error message, you get data from SQL Server Analysis Service, right? The error shows MSOLAP$AnalysisServiceWorkspace1107612610 is not found, it seems  there is some problem about your SSAS rather Power Bi desktop, please check it by SSAS Administrator. Or restart your SSAS service, get data again and check if it works fine.

        Best Regards,
        Angelia