Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am working in Power BI Desktop with Salesforce Objects, I have to combine 2 tables (relationship Many:1)
What I am trying to show in my dashboard table are some fields of the Plan table for opportunities that have a plan and blanks in case the opportunities that don't have a plan.
Due to in the Plan table the opportunities with no plan do not exist, every time I include any field of the Plan Table in the dashboard automatically removes the opportuties with no plan.
I have tried to create a new column in Table 1, with the data of table 2 where the relationship field matched with function Related but it does not allowe me to create this relationship.
Could anyone please point me in the right direction with this?
Many Thanks,
Uxia
Solved! Go to Solution.
Hi @Uxia,
I test with your sample and I found if I create relationship, these blank score and rating records will auto hide. I try to use 'show items with no data' option but not work.
For your scenario, I'd like to suggest you break relationship and create calculate column or measure with lookupvalue function to find out related score and rating.
Reference link:
Favorite Quick & Easy DAX: Lookup Values
Regards,
Xiaoxin Sheng
HI @Uxia,
Can you please share some sample data and expected result? It will be help for clarify your scenario.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft,
Thanks for the reply, I cannot share the actual data as it is confidential but I made a simple example that illustrates the situation
As you can see, only the Opportunities that exist in Table 2 are the ones shown in the final table, but I want all the opportunities in Table 1, and if these do not exist in Table 2 then blanks should appear in the missing rows.
Hope this clarifies.
Let me know if you need anything else.
Thanks again,
Uxia
Hi @Uxia,
I test with your sample and I found if I create relationship, these blank score and rating records will auto hide. I try to use 'show items with no data' option but not work.
For your scenario, I'd like to suggest you break relationship and create calculate column or measure with lookupvalue function to find out related score and rating.
Reference link:
Favorite Quick & Easy DAX: Lookup Values
Regards,
Xiaoxin Sheng
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |