Error: the column 'People[FullName]' either doesn't exist or doesn't have a relationship to any table available in the current context.

0 votes

I am trying to pull in a field from another table in my BISM model using the "RELATED" function. 

I am trying to calculate:

=CALCULATE(RELATED(People[FullName]]),USERELATIONSHIP(Def[OwnerID],People[PersonID]))

But I get the error above.

Sep 28 in Power BI by anonymous
• 4,810 points
55 views

1 answer to this question.

0 votes

Here's an example using the AdventureWorksDW data set.

EVALUATE(
    CALCULATETABLE(
        ADDCOLUMNS(
            'Internet Sales'
            ,"Order Calendar Year"
                ,CALCULATE(VALUES('Date'[Calendar Year]))
            ,"Ship Calendar Year"
                ,CALCULATE(
                    VALUES('Date'[Calendar Year])
                    ,FILTER(
                         'Date'
                        ,'Date'[DateKey] = 'Internet Sales'[ShipDateKey]
                    )
                )
            ,"Due Calendar Year"
                ,CALCULATE(
                     VALUES('Date'[Calendar Year])
                    ,FILTER(
                         'Date'
                        ,'Date'[DateKey] = 'Internet Sales'[DueDateKey]
                    )
                )
        )
    )

answered Sep 28 by Gitika
• 42,520 points

Related Questions In Power BI

0 votes
1 answer

Add Column Count_of_people across two tables to get the count of people from a city.

Hi Anitha, 1. Merge both tables, using City ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 32,490 points
102 views
0 votes
1 answer

How to add an extra column to the existing table in power bi query editor?

Hi, To create a custom column, we need to ...READ MORE

answered Feb 3 in Power BI by Rajan
10,100 views
+1 vote
1 answer

Is there a way to convert JSON data to readable table in power bi

Follow these steps step 1 - Click on ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,420 points
8,651 views
0 votes
1 answer

What are the components I need to excel to become a pro in power BI

Having knowledge about these topics is a must.  Power ...READ MORE

answered Oct 8, 2018 in Power BI by Kalgi
• 51,970 points
148 views
0 votes
1 answer

How do I label bar graph with different colors based on values from different slicers?

If the user selects only one value ...READ MORE

answered May 20, 2019 in Power BI by avantika
• 1,500 points
202 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How to make a table Hyperlink in Excel Power Pivot?

Hey, You can follow these steps to make a ...READ MORE

answered Feb 6 in Power BI by Gitika
• 42,520 points
705 views