PivotValues1 =
VAR ALLS =
    SELECTCOLUMNS (
        ADDCOLUMNS (
            ALLNOBLANKROW ( Dim_product[ProductID] ),
            "Rank"1,
            "Segmentation""Total"
        ),
        "Segmentation", [Segmentation],
        "PDC Key", Dim_product[ProductID],
        "Selection""Total",
        "Rank", [Rank],
        "Dimension"1
    )
VAR Manufacturer =
    SELECTCOLUMNS (
        ADDCOLUMNS (
            ALLNOBLANKROW ( Dim_product[ProductID], Dim_product[Manufacturer] ),
            "Rank"2,
            "Segmentation""Manufacturer"
        ),
        "Segmentation", [Segmentation],
        "PDC Key", Dim_product[ProductID],
        "Selection", Dim_product[Manufacturer],
        "Rank", [Rank],
        "Dimension"1
    )
VAR Segment =
    SELECTCOLUMNS (
        ADDCOLUMNS (
            ALLNOBLANKROW ( Dim_product[ProductID], Dim_product[Segment] ),
            "Rank"3,
            "Segmentation""Segment"
        ),
        "Segmentation", [Segmentation],
        "PDC Key", Dim_product[ProductID],
        "Selection", Dim_product[Segment],
        "Rank", [Rank],
        "Dimension"1
    )
VAR Country =
    SELECTCOLUMNS (
        ADDCOLUMNS (
            ALLNOBLANKROW ( Dim_geo[Zip], Dim_geo[Country] ),
            "Rank"4,
            "Segmentation""Country"
        ),
        "Segmentation", [Segmentation],
        "PDC Key", Dim_geo[Zip],
        "Selection", Dim_geo[Country],
        "Rank", [Rank],
        "Dimension"2
    )
RETURN
    UNION ( ALLSManufacturerSegmentCountry )
Code beautified with DAX Formatter by SQLBI