The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to Solution.
Check your data again
- validate the case (Power Query is case sensitive)
- check for trailing spaces
- check for nulls
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.
Hi actually i have used FILTER Function , and all selected Function then it is giving Correct results...
Thank you for your support
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.
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
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.
Check your data again
- validate the case (Power Query is case sensitive)
- check for trailing spaces
- check for nulls
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |