Matrix table

1) Create a disconnected “Column Layout” table

You can do this in DAX (or Power Query). This version is easiest to understand:

A) Disconnected table for Metrics

Metrics =
DATATABLE (
    "Metric", STRING,
    {
        { "OTD" },
        { "NET SALES" },
        { "COST of sales" },
        { "gross" }
    }
)

Months =
DISTINCT (
    SELECTCOLUMNS (
        'Date',
        "MonthStart", DATE ( YEAR('Date'[Date]), MONTH('Date'[Date]), 1 ),
        "MonthLabel", FORMAT ( 'Date'[Date], "MMM-yy" )
    )
)

C) Crossjoin to create the final matrix columns table

MatrixColumns =
CROSSJOIN (
    SELECTCOLUMNS ( Months, "MonthStart", [MonthStart], "MonthLabel", [MonthLabel] ),
    SELECTCOLUMNS ( Metrics, "Metric", Metrics[Metric] )
)

No relationships from MatrixColumns to your model.

2) Put fields into the Matrix

• Rows: Region, Store, Product

• Columns: MatrixColumns[MonthLabel] then MatrixColumns[Metric]

• Values: the single measure below

3) Create one “dynamic value” measure (TREATAS + SWITCH)

Matrix Value =
VAR _MonthStart = SELECTEDVALUE ( MatrixColumns[MonthStart] )
VAR _Metric     = SELECTEDVALUE ( MatrixColumns[Metric] )
RETURN
SWITCH (
    TRUE(),
    _Metric = "OTD",
        CALCULATE ( [OTD], TREATAS ( { _MonthStart }, 'Date'[MonthStart] ) ),

    _Metric = "NET SALES",
        CALCULATE ( [Net Sales], TREATAS ( { _MonthStart }, 'Date'[MonthStart] ) ),

    _Metric = "COST of sales",
        CALCULATE ( [Cost of Sales], TREATAS ( { _MonthStart }, 'Date'[MonthStart] ) ),

    _Metric = "gross",
        CALCULATE ( [Gross], TREATAS ( { _MonthStart }, 'Date'[MonthStart] ) )
)

This forces the correct month filter without needing the month to come from your real Date table (because the month is coming from the disconnected table).