Parts of table not capable of resolving connection

[Anonymous]

I have the following model:

 

With the following connections:

 

I have a table, where (for now) I am adding attributes from the following tables:

    factLocation

    factPo

    dimLocation

    dimProduct

Most of the items are added properly from all the table, but when it comes to adding items from the factPo table, I am running into a problem.

The following columns can be added fine:

    QuantityOrdered

    LineKey

    UnitCost

    ErightedCost

But if I try to add any of the following items:

    ETADate

    LocationKey

    ProKey

    RequiredDate

    SkuCode

    SkuStage

I get the following error message:

Can't display the visual. See details, and the details are:

Can't determine relationships between the fields

Any ideas?

[jdbuchanan71]

@Anonymous 

Try adding a measure into the visual.   When you add fields from 2 detail tables, the measure will help limit the number of lines returned. 

[Anonymous]

Can you explain what you mean by this?

[jdbuchanan71 · Accepted solution]

Sure, I have a model that looks like this.

If I pull a field from vCLAIM and a field from vENROLLMENT into the same visual I get the error you are seeing.  [Claim Type] is from vCLAIM and [Active] is from vENROLLMENT

But when I add a meaure to the visual powerbi is able to determine what to display.

[Anonymous]

A measure is a piece of code that is specific to the task at hand. So, what kind of measure would you apply?

[jdbuchanan71]

What measure were you trying to show in your view when you received the error?