Removing duplicates and keeping the row with highest value

[Anonymous]

Hello everyone, I am stuck in a scenario.
I have made a table visual with Employee Name(Which is a column from a table) and Utilization Rate(which is a calculated measure). As given below :

Employee Name	Utilization Rate
a	100.00%
b	100.00%
c	100.00%
c	0.00%
d	35.71%
e	0.00%
e	0.00%
e	0.00%
f	72.62%
f	70.24%
g	100.00%

From this table visual I want to remove the duplicated employee names. I want to keep only those rows with the highest Utilization Rate as shown below :

Employee Name	Utilization Rate
a	100.00%
b	100.00%
c	100.00%
d	35.71%
e	0.00%
f	72.62%
g	100.00%

Here I want to remove the rows in red colour. As shown in the immage below :

Can anyone help me solve this problem?

[CNENFRNL]

You even don't need an explicit measure to achieve this,

[Anonymous]

Hi @CNENFRNL thanks for your input
But since Uilization Rate is a measure I'm not getting these options.

Regards,
Aditya

[BeaBF]

@Anonymous You can create a calculated table as:

Tabella 2 = SUMMARIZE(SELECTCOLUMNS('Tabella (4)',

"Employee Name", 'Tabella (4)'[Employee Name]),

[Employee Name],

"Utilization Rate", MAX('Tabella (4)'[Utilization Rate]))

Where Tabella(4) is your native Table.

The result is the right table:

BF

[Anonymous · Accepted solution]

HI @Anonymous,

You can try to use the following measure to get the max Utilization Rate based on the current employee group:

Measure =
VAR cEName =
    VALUES ( 'Table'[Employee Name] )
RETURN
    MAXX (
        FILTER (
            SUMMARIZE (
                'Table',
                'Table'[Employee Name],
                "mURate", MAX ( 'Table'[Utilization Rate] )
            ),
            [Employee Name] IN cEName
        ),
        [mURate]
    )

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @BeaBF ,
since Utilization Rate is a measure, 
I'm not getting the option to aggregate it.

Anyways, thanks for your input.

Aditya

[BeaBF]

@Anonymous  can you paste the code of that measure?

BF

[Daryl-Lynch-Bzy]

Hi @Anonymous , we would need more details about the Data Model and DAX Measures to provide a clear solution.  It is likely that Many to One or equivalent is causing the issue.  But I am wondering if you have the following situation occuring.   How to show a name more than once in Power BI - YouTube