Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PowerBIDine
Helper I
Helper I

Data Modelling and Relationship Problem

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

 

PowerBIDine_0-1712416709150.png

 

 

 

Dim Table

PowerBIDine_1-1712416709155.png

 

Fact Table

 

PowerBIDine_0-1712416758468.png

 

3 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

Check your data again

 

- validate the case  (Power Query is case sensitive)

- check for trailing spaces

- check for nulls

View solution in original post

Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

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

 

Thank you for your support

View solution in original post

5 REPLIES 5
PowerBIDine
Helper I
Helper I

 

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

 

PowerBIDine_0-1715838055882.png

 

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......

PowerBIDine_1-1715838413791.png

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

 

 

 

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...

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

 

Thank you for your support

Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

Check your data again

 

- validate the case  (Power Query is case sensitive)

- check for trailing spaces

- check for nulls

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.