Need help with visual and a dax

Hi Migsmix ,

For this you need to make the following steps:

• Create a table with the cluster, measures and a total similar to the bottom one:

• Add the following measures to your model:

Distribution = COUNT(Table1[Inventory (Q)])

Number of Stores = CALCULATE(DISTINCTCOUNT(Table1[Store Name]),ALLSELECTED(Table1   ), VALUES(Table1[Cluster]))

Percentage = Divide( [Distribution] , [Number of Stores])

TBS =
VAR TotalStores =
    SUMX (
        SUMMARIZE (
            CALCULATETABLE ( Table1, ALLSELECTED ( Table1 ) ),
            Table1[Cluster],
            "Stores", [Number of Stores]
        ),
        [Stores]
    )
RETURN
    IF (
        ISINSCOPE ( Table1[Cluster] ),
        BLANK (),
        DIVIDE ( [Distribution], TotalStores )
    )

VAlues = 
SWITCH (
    TRUE (),
    SELECTEDVALUE ( Split[Clusters] ) <> "Total"
        && SELECTEDVALUE ( Split[Measure] ) = "Distribution", CALCULATE ( [Distribution], Table1[Cluster] IN VALUES ( Split[Clusters] ) ),
    SELECTEDVALUE ( Split[Clusters] ) <> "Total"
        && SELECTEDVALUE ( Split[Measure] ) = "Number of Stores", CALCULATE ( [Number of Stores], Table1[Cluster] IN VALUES ( Split[Clusters] ) ),
    SELECTEDVALUE ( Split[Clusters] ) <> "Total"
        && SELECTEDVALUE ( Split[Measure] ) = "Percentage",
        FORMAT (
            CALCULATE ( [Percentage], Table1[Cluster] IN VALUES ( Split[Clusters] ) ),
            "0%"
        ),
    SELECTEDVALUE ( Split[Clusters] ) = "Total"
        && SELECTEDVALUE ( Split[Measure] ) = "TBS", FORMAT ( [TBS], "0%" )
)

• Setup you matrix in the following way:
  • Rows: 
    • Code2
    • Name
  • Columns:
    • Cluster (from the new table)
    • Measure(from the new table)
  • Values
    • Values measure
  • Turn of steped layout
  • Drill down on the columns and rows until the last level
  • turn off totals

Result below and in attach PBIX file:

Add the following measure:

VAlues Colouring =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( Split[Clusters] ) <> "Total"
        && SELECTEDVALUE ( Split[Measure] ) = "Percentage",
        CALCULATE (
            SWITCH (
                TRUE (),
                [Percentage] < 0.5, "Red",
                [Percentage] < 1, "Yellow",
                "Green"
            ),
            Table1[Cluster] IN VALUES ( Split[Clusters] )
        )
)