EVALUATE
    VAR CCNFilters =

    { ""}
    VAR UserFilters =

    { ""}
    VAR SalesOfficeFilters =

    { ""}
    VAR StartDate =
    DATE(2019,1,1)
    VAR EndDate =
    DATE(2019,5,26)
    VAR CurrencyCode = "USD"
    RETURN
    CALCULATETABLE (
    SUMMARIZECOLUMNS (
    'Date'[Calendar Year],
    'Date'[Month of Year],
    FILTER (
    'CCN',
    SWITCH (
    COUNTROWS ( FILTER ( CCNFilters, [Value] <> "" ) ) > 0,
    TRUE, 'CCN'[CCN Code] IN CCNFilters,
    FALSE, 'CCN'[CCN Code] IN ALL ( 'CCN'[CCN Code] )
    )
    ),
    FILTER (
    'Sales Office',
    SWITCH (
    COUNTROWS ( FILTER ( SalesOfficeFilters, [Value] <> "" ) ) > 0,
    TRUE, 'Sales Office'[Sales Office Code] IN SalesOfficeFilters,
    FALSE, 'Sales Office'[Sales Office Code] IN ALL ( 'Sales Office'[Sales Office Code] )
    )
    ),
    FILTER (
    'User',
    SWITCH (
    COUNTROWS ( FILTER ( UserFilters, [Value] <> "" ) ) > 0,
    TRUE, 'User'[User Principal Name] IN UserFilters,
    FALSE, 'User'[User Principal Name] IN ALL ( 'User'[User Principal Name] )
    )
    ),
    "New Account Count", [New Account Count],
    "Booked Amount", CALCULATE (
    [Booked Amount],
    'Account'[Creation Date] > StartDate
    && 'Account'[Creation Date] < EndDate
    ),
    "Currency Code", [Evaluation Currency Code]
    ),
    'Date'[Full Date] > StartDate,
    'Date'[Full Date] < EndDate,
    'Report Currency'[Currency Code] = CurrencyCode
    )