Forum Discussion
2 Tables - Show blank rows
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 Anonymous,
Thanks for the reply, I cannot share the actual data as it is confidential but I made a simple example that illustrates the situation
- This would be Table 1 with all the opportunitities:
- This would be Table 2 with the Plan and the data
- This is what I want to achieve:
- This is actually what I get:
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 Anonymous
Here the missing table 2:
Thanks,
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 ShengHi Anonymous,
Thanks for the tip. I actually did that yesterday and it worked.
Thanks,
Uxia