None Conformed Dimensions

[DebbieE]

Say you have the following model (2 Fact tables with the only relationship via account and time

Obviously you can put together a table from

Year month (From Time) AccountCode (FromAccount) Category (From Product) Volume (From f Sales)

No problems

You can put together a table

Year month (From Time) AccountCode (FromAccount) Visit Status (From visit) NoOfVisits (From f Visits)

No problems

Try and put everything together in one table and it cant be done Cant Determine Relationships between the fields

This is because of Product information in the table. Remove that and its fine

How would you go about resolving this? 

[v-diye-msft]

Hi @DebbieE 

Sorry I didn't figure out what you are looking for. could you please kindly specify more? please refer to below article to get your question answered more quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 

[DebbieE]

Obviously you can put together a table from

Year month (From Time) AccountCode (FromAccount) Category (From Product) Volume (From f Sales)

No problems

You can put together a table

Year month (From Time) AccountCode (FromAccount) Visit Status (From visit) NoOfVisits (From f Visits)

No problems

Try and put everything together in one table and it cant be done 'Cant Determine Relationships between the fields'

This is because of Product information in the table. Remove Product and its fine

How would you go about resolving this in by changing the model. This is none conformed Dimensions over in Oracle

(From Time)  (FromAccount) (From Product)    (From f Sales)         (From visit)        (From f Visits)

Year month  AccountCode    Category              Volume                 Visit Status       NoOfVisits

As an extra. I thought merge might be the answer, Merge Product factory into my f sales table specifically for this issue

My thought was, I could use Product category in the fact table for this specific issue.

However when i recreated the table

(From Time)  (FromAccount) (From f Sales merge)    (From f Sales)         (From visit)        (From f Visits)

Year month  AccountCode    Category                       Volume                 Visit Status       NoOfVisits

I still get the error message

'cant display the data because Power BI cant determine the relationship between two or more fields'

So my merge idea hasnt worked and Im a bit stumped 

[DebbieE · Accepted solution]

got it. Basically, I merged the Product data item into fsales to used in the table 

then I changed the filter direction to Both between f-sales and time and the solution now works.

So for this none conformed visual, Merging the data item in from the dim that doesnt belong to both facts and then set the relationship direction to both between date and fact and I think this is working