Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

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

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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] )
    )
)

     

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    Hello @Syndicate_Admin ,

    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