Can't find source for a calculated table in tabular model

Fra1978 126 Reputation points
2021-02-02T10:44:38.103+00:00

I am reviewing a Cube, and I have table named WIPs, which is a calculated table with code: FILTER ( DATATABLE("WIP's" , STRING , {{}}) , 0 )

I have a few questions:

I am wondering if its auto-referencing and because TableName field doesn’t admit the caracter: it gets removed?!

If its not auto-referencing, then ;WIPs table points to WIP’s … I am unable to find this WIP’s table… (it’s not in the model or at source…)

I also do not understand what the code is doing? What is {{}}?

Any clarification will be appreciated.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Lukas Yu -MSFT 5,816 Reputation points
    2021-02-03T02:42:36.503+00:00

    Hi,

    The "WIP's " is the column name in the created table, not the table name. You would have your table name when you input the dax expression.

    So I am guessing your full expression need to be

    WIP's = FILTER ( DATATABLE("WIP's" , STRING , {{}}) , 0 )  
    

    The {{}} is the content in of the column in created table. In you case, it is an empty string.

    You could understand it more clearly if you try similar :

    Try to see the results of :

    TestTable= DataTable("Name", STRING,    
                   "Region", STRING    
                   ,{    
                            {" User1","East"},    
                            {" User2","East"},    
                            {" User3","West"},    
                            {" User4","West"},    
                            {" User4","East"}    
                    }    
               )    
    

    See reference here : DATATABLE


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November