Show top 50% number in table

[heartless99]

Hello, 

i want to convert this excel Sheet  in POWER BI Table. The help needed is to show YES under Top 50% column if the Employee is within the top 50% of the population and the count of employee will be dependent on the filters selected in power BI.

in this example, I have a total of 16 employees. the top 50% is 8 and i want to show the "Yes" beside those within the top 50% of the population and "No" otherwise.

Thanks for the help

[heartless99]

Thanks a lot. This solved my problem. 😃 

[MFelix · Accepted solution]

Hi @heartless99,

Assuming that the Rank you have is a measure based on the % create the following measures:

Ranking =
RANKX (
    ALL ( Table1[ID]; Table1[Name]; Table1[Rank] );
    CALCULATE ( SUM ( Table1[Rank] ) )
)

Top 50% =
IF (
    [Ranking]
        <= CALCULATE (
            DISTINCTCOUNT ( Table1[Name] );
            ALL ( Table1[Name]; Table1[ID]; Table1[Rank] )
        )
            / 2;
    1;
    0
)

The second one is to make the conditional formatting of the column Rank or any other you would like then just do a condittional formating.

Regards,

MFelix