Grouping measure values ​​and adding them to the hierarchy

[Eliarge]

I have a matrix. The matrix has factory names and a metric called "General KPI". I want to seperate "General KPI" by groups.If "Genel KPI" between 0-1,this is mean "green". If "Genel KPI" between 1-5,this is mean "orange ". If "Genel KPI" greater than 5,this is mean "red". 

I want to show each group as in the figure below. I couldnt do this step.

How can I do that ? 

[Anonymous · Accepted solution]

Hi @Eliarge ,

Please have a try.

If KPI is also a measure. You can create a measure.

measure =
IF (
    [KPI] >= 0
        && [KPI] < 1,
    "Green",
    IF ( [KPI] >= 1 && [KPI] < 5, "Orange", IF ( [KPI] >= 5, "Red" ) )
)

 If KPI is a column. You can create a measure like the following:

measure =
IF (
    MAX ( table[KPI] ) >= 0
        && MAX ( table[KPI] ) < 1,
    "Green",
    IF (
        MAX ( table[KPI] ) >= 1
            && MAX ( table[KPI] ) < 5,
        "Orange",
        IF ( MAX ( table[KPI] ) >= 5, "Red" )
    )
)

Then you would need to create a disconnected table as described in this similar blog. Then add the Measure Column to the Matrix.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Eliarge]

I adapted what you wrote according to my needs and solved my problem. Thank you.