Create an Azure Analysis Services cube [Mcube] with a single expression [SharedExpression] that is exposed through which contents is exposed through [SharedExpressionTable] table. All for the sake of reaching for the #shared construct

CreateAzASCube1400.tmsl

{
  "create": {
    "database": {
      "name": "Mcube",
      "compatibilityLevel": 1400,
      "model": {
        "culture": "en-GB",
        "expressions": [
          {
            "name": "SharedExpression",
            "kind": "m",
            "expression": "#shared"
          }
        ],
        "tables": [
          {
            "name": "SharedExpressionTable",
            "columns": [
              {
                "name": "Name",
                "dataType": "string",
                "sourceColumn": "Name"
              },
              {
                "name": "Value",
                "dataType": "string",
                "sourceColumn": "Value"
              }
            ],
            "partitions": [
              {
                "name": "Partition",
                "dataView": "full",
                "source": {
                  "type": "m",
                  "expression": "#sections[main][SharedExpression]"
                }
              }
            ]
          }
        ]
      }
    }
  }
}