Forum Discussion
Getting results from two tables
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
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
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
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
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
how did you create client new table?
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