Data Modelling Workout 08 - DAX Measures
========================================

Total Trips = 
COUNTROWS( Trips ) + 0

July Trips = 
CALCULATE(
    [Total Trips],
    REMOVEFILTERS(),
    FILTER( ALL( Dates ), Dates[Month Name] = "July" )
) + 0

August Trips = 
CALCULATE(
    [Total Trips],
    REMOVEFILTERS(),
    FILTER( ALL( Dates ), Dates[Month Name] = "August" )
) + 0

September Trips = 
CALCULATE(
    [Total Trips],
    REMOVEFILTERS(),
    FILTER( ALL( Dates ), Dates[Month Name] = "September" )
) + 0

Weekday Trips = 
CALCULATE( 
    [Total Trips], 
    FILTER( Dates, Dates[Day Type] = "Weekday" ) 
) + 0

Weekend Trips = 
CALCULATE( 
    [Total Trips], 
    FILTER( Dates, Dates[Day Type] = "Weekend" ) 
) + 0

Avg. Bus. Day Trips = 
CALCULATE(
    [Total Trips],
    REMOVEFILTERS(),
    FILTER( ALL( Dates ), Dates[IsBusinessDay] = TRUE() )
) + 0

Avg. Non-Bus. Day Trips = 
CALCULATE(
    [Total Trips],
    REMOVEFILTERS(),
    FILTER( ALL( Dates ), Dates[IsBusinessDay] = FALSE() )
) + 0

Morning Rush Hour Trips = 
CALCULATE(
    [Total Trips],
    REMOVEFILTERS(),
    FILTER( Dates, Dates[IsBusinessDay] = TRUE() ),
    FILTER( Times, Times[Hour Number] >= 6 && Times[Hour Number] < 9 )
) + 0

Afternoon Rush Hour Trips = 
CALCULATE(
    [Total Trips],
    REMOVEFILTERS(),
    FILTER( Dates , Dates[IsBusinessDay] = TRUE() ),
    FILTER( Times, Times[Hour Number] >= 15 && Times[Hour Number] < 18 )
) + 0