Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
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 revie...
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper 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] )
    )
)