Forum Discussion

Pk8524's avatar
Pk8524
Helper I
11 months ago
Solved

Getting results from two tables

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's avatar
    FBergamaschi
    11 months ago

    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

8 Replies