Getting results from two tables

[Pk8524]

I have following model:

The goal is to show in one table list of all clients with targets.

Issue is that:

- table should be showing all clients + new potential clients. If I am choosing clientname from dimclient - i have list of all clients but missing the potential ones (showing as blank). If I am choosing clientname from dimTarget - i get only clients which have targets and new ones, but the ones which do not have targets, and have sales - do not see.

How to resolve this puzzle?

https://drive.google.com/file/d/1ZKSMcSfPVQ191QyEqTOxlXELrOfd32Kl/view?usp=sharing 

[v-prasare]

Hi @Pk8524,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

@FBergamaschi ,Thanks for your prompt response

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[FBergamaschi]

Hi @Pk8524,

you should have a table with all customers in, so your dimClient should include actual and potential customers. 

I shall attach the review file shortly

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[FBergamaschi]

My reviewd file is here

https://drive.google.com/drive/folders/1OI6wZqhUciSZk2OFy9hlb6WnP-xjyo88?usp=sharing

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[Pk8524]

https://drive.google.com/file/d/1Qur4w3cjsVozvSUtluH6PLD7c5S1zjJB/view?usp=sharing 

i added some data to targets table - and the problem is that now it is showing clientname which are not only for selected person. Intead of creating new client table, i created seperated table + treatas

[Pk8524]

how did you create client new table?

[FBergamaschi]

I created it by hand to show you how it should be done

Best

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[FBergamaschi · Accepted solution]

I have seen your file, please can you insert new data into the file I sent you and try again? I have already fixed a few things in my file. If you assign the Target to the person that will work , see here example from my file shared with you

updated file in the same location as before

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[FBergamaschi]

Are you using my file for this furthe rmodifications? The tables should be adjusted to assign the new customers to the Salesman

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI