Forum Discussion

Uxia's avatar
Uxia
New Member
8 years ago
Solved

2 Tables - Show blank rows

Hello,   I am working in Power BI Desktop with Salesforce Objects, I have to combine 2 tables (relationship Many:1)    Table 1 (Opportunities): contains all opportunities Table 2 (Plan) : conta...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

Uxia's avatar
Uxia
New Member
8 years ago

Hi Anonymous,

 

Thanks for the tip. I actually did that yesterday and it worked.

 

Thanks,

 

Uxia