Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi BI Community Team,
I have a table of Visit Plan and we're looking for Avg. Visit per day by sales rep & Team.
Logic (by sales rep) : no. of visit plan / no. of working day
Logic (by team) : no. of visit plan / total no. of sales rep belong to this team / no. working day
I have tried some measure, but it's not working correctly as the screenshot below.
Sample pbix - https://drive.google.com/drive/folders/11WhohpJrJSWio_WNbesqlQCMjaTn1spq?usp=sharing
Expect Result
Any suggestion?
Thanks and Regards,
Hello @ADSL ,
This video helped me in a similar situation as yours so please check it.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |