cancel
Showing results for
Did you mean:

## Create a range on percentages

Good morning community,

I have a table with the reviews and the percentages that it supposes for each seller, but I would like to create a range of percentages, where it will indicate how many reviews are between 0% and 30%, how many between 30% and 90% and how many between 90% and 100%.

I accompany an image to better understand what I need.

Thank you all very much for your help!

2 REPLIES 2

Thank you very much for your quick response. I really believe that it is the solution, but for some reason he tells me all of them and puts me that, although they have percentages higher than 30%, they are within the range between 0% and 30%.

I think I have to look at other details, such as the relationships or calculations that are involved in the creation of the table.

Thank you very much again for your help.

Best regards

Jose Luis

Super User

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

``````Revisiones measure: =
SUM( Data[Revisiones] )``````

``````Percentage: =
DIVIDE (
[Revisiones measure:],
CALCULATE ( [Revisiones measure:], ALLSELECTED ( Data[Cliente] ) )
)``````

``````Group: =
VAR _percentage = [Percentage:]
RETURN
SUMMARIZE (
FILTER ( 'Group', _percentage >= 'Group'[Min] && _percentage < 'Group'[Max] ),
'Group'[Group]
)
``````

``````Clinete count by group: =
COUNTROWS (
FILTER (
VALUES ( Data[Cliente] ),
[Percentage:] >= MAX ( 'Group'[Min] )
&& [Percentage:] < MAX ( 'Group'[Max] )
)
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Announcements

#### Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

#### Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

#### Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

#### Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors