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

Walgama — Fri, 04 Nov 2022 16:57:35 GMT

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

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

Anonymous — Mon, 07 Nov 2022 01:39:51 GMT

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

topic Re: Lab Practices (Lab 06A - Using DAX in Power BI Desktop Part 1) in Developer

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

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