Lab Practices (Lab 06A - Using DAX in Power BI Desktop Part 1)

[Walgama]

Hi All,

Please help me to overcome this ambiguity when viewing the total sales by using two queries, the Salesperson and the salesperson (performance) query.  In the performance report, the total sales are wrong against the actual sales done by each person. Please refer to the attached screenshot. 

Please help me to understand this situation

Thanks 

[Anonymous]

Hi @Walgama ,

There is no screenshot in your post, could you please share it again? And in order to make troubleshooting ang give you a suitable solution, could you please provide more raw data in  the Salesperson and the salesperson (performance) query (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards