Data Labels in Table

[StefanK]

This is my Table in Power BI Desktop and the according Data Sheet:

How can I show the Name-Code of the Employee in the Power BI Table, next to the Quick Measure with his Sales?

[Vvelarde · Accepted solution]

@StefanK

Hi, Please try with this measure:

EmployeeCode =
VAR SALEMAX = [Sale max per Employee]
VAR TABLEEMPLOYEE =
    SUMMARIZE (
        Table1;
        Table1[Employee];
        "SALES"; CALCULATE ( SUM ( Table1[Sale] ) )
    )
RETURN
    CALCULATE (
        VALUES ( Table1[Employee] );
        FILTER ( TABLEEMPLOYEE; [SALES] = SALEMAX )
    )

Regards

Victor

Lima - Peru

[StefanK]

I don't understand exactly, how your solution works, but it does work perfectly, thx for that!

[Vvelarde]

@StefanK

Hi, The measure work in this way:

First i declare two variables :

1. With the MaxSale (Your measure)

2 A variable to store a "temporal table" with the summarize of employees and his sales.

After that create a 1 column table (in this case with Values) of the employee where the sales are equal to MaxSale

The issue is when 2 employees had the MaxSale. In this case you should evaluate what desire to show. Only One Employee or Both.

Regards

Victor

Lima - Peru

[StefanK]

@VvelardeThank you for the explanation.

Unfortunately I just figured out, that this solution doesn't work, when I use the date-slicer. Do you have an idea?

[StefanK]

anybody?