Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello Community,
So to start with, I have a table with my employees and list of customers they dealt with on a day to day basis. I am able to get the count by day/week/month/quarter/year in a perfect way by having a Calender table and linking these two tables.
Problem is when I calculate averages per month or per week, it does not include rows where 0 customers were seen. Hence the averages are higher than they should be.
I have attached the dax below (created by quick measure) where I calculate the average per month and week. I have an interactive dashboard and I also need the values to change when a selection has been made. Like a particular employee etc.
Your help would be appreciated.
Update:
I just solved this by creating two measures, one for distinct count of week and other toal encounters and also tried your way. The results for both the method are same. However, your method is easy and quick.
The next issue I have is few employees started in the middle of the year, say June. Both the methods mentioned above is calculating all the weeks since Jan.
How do I set a conditional saying if any week has an input (basically means new employee joined), then start doing rolling average from that point forward.
I am also anticipating another issue where an employee left, so provide a condition for a stop for particular employees.
Solved! Go to Solution.
@MuthalibAbdul Try adding + 0 right after your CALCULATE statement
@MuthalibAbdul Try adding + 0 right after your CALCULATE statement
Perfect, I just solved this by creating two measures, one for distinct count of week and other toal encounters and also tried your way. The results for both the method are same. However, your method is easy and quick.
The next issue I have is few employees started in the middle of the year, say June. Both the methods mentioned above is calculating all the weeks since Jan.
How do I set a conditional saying if any week has an input (basically means new employee joined), then start doing rolling average from that point forward.
I am also anticipating another issue where an employee left, so provide a condition for a stop for particular employees.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |