Matrix & Slicer Not Playing Together

leebaldwin 

Hi,

You may need to use a disconnected table and use this table for your slicer.

AgingBuckets = DATATABLE(
    "Bucket", STRING,
    {
        {"Current"},
        {"1-30 Days"},
        {"31-60 Days"},
        {"61-90 Days"},
        {"91-120 Days"},
        {"121-150 Days"},
        {"151-180 Days"},
        {"181-365 Days"},
        {">365 Days"}
    }
)

then try using SWITCH and SELECTEDVALUE to switch your measures

SelectedBucketValue = 
SWITCH(
    SELECTEDVALUE('Aging Bucket'[Bucket]),
    "Current", [Current],
    "1-30 Days", [1_30_Days],
    "31-60 Days", [31_60_Days],
    "61-90 Days", [61_90_Days],
    "91-120 Days", [91_120_Days],
    "121-150 Days", [121_150_Days],
    "151-180 Days", [151_180_Days],
    "181-365 Days", [181_365_Days],
    ">365 Days", [Over_365_Days]
)