topic Re: Grouping measure values and adding them to the hierarchy in DAX Commands and Tips

Grouping measure values and adding them to the hierarchy

Eliarge — Fri, 10 Mar 2023 12:01:58 GMT

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 ?

Re: Grouping measure values and adding them to the hierarchy

Anonymous — Wed, 15 Mar 2023 02:30:45 GMT

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.

Re: Grouping measure values and adding them to the hierarchy

Eliarge — Thu, 16 Mar 2023 09:50:38 GMT

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

topic Re: Grouping measure values ​​and adding them to the hierarchy in DAX Commands and Tips

Grouping measure values ​​and adding them to the hierarchy

Re: Grouping measure values ​​and adding them to the hierarchy

Re: Grouping measure values ​​and adding them to the hierarchy

topic Re: Grouping measure values and adding them to the hierarchy in DAX Commands and Tips

Grouping measure values and adding them to the hierarchy

Re: Grouping measure values and adding them to the hierarchy

Re: Grouping measure values and adding them to the hierarchy