Forum Discussion

StefanK's avatar
StefanK
New Member
8 years ago
Solved

Data Labels in Table

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's avatar
    Vvelarde
    8 years ago

    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

Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

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