Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I want to display a table of data contain in a table that doesn't match the other table data.
When i only put data of a single table, the data are correctly display but when i put the data of the other table all the data that doesn't "match" ( the one i want to keep ) disappear.
Any idea ?
Thanks
@Anonymous,
It's hard to give you the root reason that cause this issue based on your description. You could provide us more detail information.
If possible, provide us your PBIX file, so that we can make further analysis.
Regards,
Charlie Liao
What i mean by "all the data that doesn't match" :
I have one table that containt all the data i want to show, i have another table that only containt the id that match the id of the first table. I want to show all the row where theyre is not match between the two id.
The expected result is a table like this one :
Thanks,
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |