Table with count in each percentage range/bucket

[Anonymous]

Hello,

Please see the screenshot below. I have a list of managers with different scores (percentages). I want to take the count of managers in each percentage range and show in a table/matrix. What is the best way to display this in Power BI? Thx!!

[Anonymous]

HI @Anonymous,

It sounds like a segment related requirement, you can take a look at the following blog about dynamic segmentation if helps:

Dynamic segmentation – DAX Patterns

For conditional formatting, you can write a measure formula to calculate the aggregate value, then you can use it as a condition to return different color codes and use it in color formatting.

Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

[Anonymous]

[Anonymous]

Hi,

That doesn't work. It just shows the manager names, not a count 

[Anonymous]

Also the score is based on an average of several scores, not just 1. Not sure how to count/summarize this?

[Anonymous]

In you exemple the names of manager was not in the display.

But anyway to have the count, you have to put the field manager with a count on choice

[Anonymous]

Here's a better snapshot of the data in a matrix. I don't have the count option as a dropdown. Manager is in rows, testyswitch (which buckets the scores) is in values. If I drop down values in Visualizations, I see no Count

[Anonymous]

choose count

[Anonymous]

Hi,

that doesn't show up in the dropdown ( see below). and I can't  switch manager to values, and testyswitch to rows (it won't allow it).

[Anonymous]

Sp try to send me uor pbix if you can

[Anonymous]

adda column to your table

Score Bucket =

SWITCH(true(),Manager[Score]<0.6,">60%",

Manager[Score]<=0.65,"60%-65%",

Manager[Score]<=0.7,"65%-70%",

Manager[Score]<=0.75,"70%-75%",

Manager[Score]>0.75,">75%")

after you will use this field for the display

[Anonymous]

Thx. How do I count the grouped values (see below for a screenshot of output based on switch)? the column 'Score' was originally a calculated field, like so: Score = DIVIDE(SUM(Data[Numerator]),(SUM(Data[Denominator])))