Average by weekday (even without data)

Hi Aho00, you need to divide the number of machine rows by how many times that weekday actually appears in your selected month/year (based on your Calender table), not just by the number of days where you have data.

Try this:

Average Machines per Weekday =
VAR WeekdayName =
    SELECTEDVALUE ( 'Calendar'[Weekday] )

VAR DaysOfThisWeekday =
    CALCULATE (
        DISTINCTCOUNT ( 'Calendar'[Date] ),  
        REMOVEFILTERS ( Table1 ),            
        KEEPFILTERS ( 'Calendar'[Weekday] = WeekdayName ),
        ALLSELECTED ( 'Calendar'[Date] )      
    )

RETURN
DIVIDE ( COUNTROWS ( Table1 ), DaysOfThisWeekday, 0 )

Use your Weekday-column from your Calendar-dimension on your bar chart axis and turn on "show items with no data" (right-click on the field in the X-Axis to show this dialogue):