Forum Discussion
Solved
Direct Query DataVerse left join between two entites
Hi All, I'm new to Power BI and I struggle to make the report that I need. I'm using Direct query to get data from DataVerse (dynamics 365). I have two entities contact and User and what I want to...
HichamGRC , You need to create join between contact and systemuser ( Many to one)
And then just create a measure
count(contact[contact.createdby])
and plot it in visual with systemuser.fullname and sort visual on This new measure
Hi amitchandak
Thanks for the help, I spent time working on data modeling and I achieved that by creating relationships.