Data Modelling and Relationship Problem

[PowerBIDine]

Hi all,

Thanks for your valueable time to read my post 

I have Dim Table (used Distinct Function) and fact table When try to make a relationship between these 2 table , PowerBI Suggested only Many to many.

How to Fix this , there is no Duplicate in Dim_Table also I have used DISTINCT function

Please help on this

Dim Table

Fact Table

[lbendlin · Accepted solution]

Check your data again

- validate the case  (Power Query is case sensitive)

- check for trailing spaces

- check for nulls

[Ashish_Mathur · Accepted solution]

Hi,

That is happening becasue there is a blank in the Dim table (first entry there).  Create this table in the Query Editor instead and remove the nulls/blanks.  Now you will be able to create a Many to One relationship.

Hope this helps.

[PowerBIDine]

Dear Experts,

Kindly see my Measure , and all Filter , My measure is working well and give the expected results.

when not selected anything in "Life category" FILTER , 

Measure Logic :-   Based on String ( based on once cell whole text, wherever  it occurs we have to count and show it the individual text aganist

But when i have selcted the "Life Cycle status" , it is showing wrong values, if not selected the Filter , that time also there is only this 2 category , but when i have selected manually 2 items , it is showing wrong number based on Competitor wise......

also when i have selected "IN Process" or "Open" Seperately  it is working , but when selected both it is showing Wrong values.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[PowerBIDine · Accepted solution]

Hi actually i have used FILTER Function , and all selected Function then it is giving Correct results...

Thank you for your support

[Ashish_Mathur · Accepted solution]

Hi,

That is happening becasue there is a blank in the Dim table (first entry there).  Create this table in the Query Editor instead and remove the nulls/blanks.  Now you will be able to create a Many to One relationship.

Hope this helps.

[lbendlin · Accepted solution]

Check your data again

- validate the case  (Power Query is case sensitive)

- check for trailing spaces

- check for nulls