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

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

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