Forum Discussion

Andres_Maldo's avatar
Andres_Maldo
Frequent Visitor
4 years ago
Solved

Grouping measures in a matrix

Hi, Guys. I have 4 measures (ROI, EBITDA, KPI 1, KPI 2) and I would like to classify in groups:   FINANCE: ROI, EBITDA SALES: KPI 1, KPI 2   And I woud like to get this matrix: I appreci...
Andres_Maldo's avatar
Andres_Maldo
Frequent Visitor
4 years ago

Hi, ALLUREAN.

Thanks, but I have measures instead of columns. And I need to be measures. I am wondering is there is a way to group these measure in a matrix.

ALLUREAN's avatar
ALLUREAN
Icon for Solution Sage rankSolution Sage
4 years ago

I use your 4 measures into one, not columns

  • Andres_Maldo's avatar
    Andres_Maldo
    Frequent Visitor
    4 years ago

    Thanks, I see. That´s an interesting approach, but what if I want KPI1 as a decimal number, KPI2 as a whole number and ROI as a percentaje? And I want to use conditional formatting in just one measure?

      • Andres_Maldo's avatar
        Andres_Maldo
        Frequent Visitor
        4 years ago

        Hi, ALLUREAN.

        I used a similar dax for colors, and it worked for conditional formatting.

         

        Colors =
        VAR Selected = SELECTEDVALUE(HeaderTable[Level2])
        var x = IF(HeaderTable[ROI] > 0.10, "#A0D1FF")
        var y = IF(HeaderTable[KPI1] > 30, "green", "red")
        RETURN
        SWITCH(TRUE(),
        Selected = "ROI", x,
        Selected = "KPI1", y
        )