Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I created a business days which is the distinct count of days of the date column. I had created measure for Avg Sales and my measure is total sales/business days, but for this division the avg sales is calculated as total sales/7 instead of total sales/11.
How can we make sure that the avg sales for all the divisions are calculated based on total business days irrespective of how many business days is for different divisions.