Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

bottom 10%

Hello Community,   I have a very simple dataset showing a dealer's customer satisfaction score %.  Once the data is imported into PowerBI, how can I create a new column that will auto-populate "yes...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Hi Anonymous 

    Here is the formula, change the rate as you wish

    Yes or No =
    var DealerScore = Sheet1[Customer Satisfaction]
    Return
    IF( DealerScore < 0.5 , "Yes", "No")
     
CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Anonymous , you might want to try following formulae in calculated columns

 

Bottom 10% = 
VAR __n = COUNTROWS ( 'Customer Satisfaction Score' ) * .1
RETURN
    IF (
        COUNTROWS (
            FILTER (
                'Customer Satisfaction Score',
                'Customer Satisfaction Score'[Customer Satisfaction]
                    < EARLIER ( 'Customer Satisfaction Score'[Customer Satisfaction] )
            )
        ) < __n,
        "Yes",
        "No"
    )

 

or

 

Bottom 10% Rankx = 
VAR __n = COUNTROWS ( 'Customer Satisfaction Score' ) * .1
VAR __rank =
    RANKX (
        'Customer Satisfaction Score',
        'Customer Satisfaction Score'[Customer Satisfaction],
        ,
        ASC
    )
RETURN
    IF ( __rank <= __n, "Yes", "No" )