Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Tara_01
Helper II
Helper II

Employee of the month

So here I will explain in detail so my team wants to calculate the best employee of the month. The data is as shared in the screen shot below, 

Tara_01_0-1655119201120.png

 

 


The employee should have maximum total hrs, Minimum waiting for task, zero QA bug, zero Process bug

this is the simple logic behind it. Now this is May month data,  I need a measure to sum the values of Individual name for that month and compare with the MAX & Min values for eg,

 

Tara_01_1-1655119201159.png

 

As highlighted in the table, PowerbI should first sum all the values against each name and then perform the aggregation operations here from the table its clearly seen that Ankita is the best performer of the month.

In the above screenshot total working hours of ankita is 22 (max), waiting for task in 10(min), QA miss is zero & process bus is also zero. I need this dynamic everymonth it should be updated.

 

I want to basically understand the best performer for that month. Also the show card shouldn't change with any filter applied.

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@Tara_01 attached the file with the solution:
Best Empoyee.pbix
Pay attention I also added a calculated column for the month.

 

SpartaBI_0-1655122222812.png

 


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

View solution in original post

6 REPLIES 6
SpartaBI
Community Champion
Community Champion

@Tara_01 attached the file with the solution:
Best Empoyee.pbix
Pay attention I also added a calculated column for the month.

 

SpartaBI_0-1655122222812.png

 


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

Thankyou so much. It worked you saved me 😄 ! I am newbiee to powerBi. It would be of great help if you could guide me how can I improve my knowledge and usage of DAX  

SpartaBI
Community Champion
Community Champion

Sure, that's easy.

www.sqlbi.com 
One stop shop and the best one for DAX 🙂

Okay thankyou !

SpartaBI
Community Champion
Community Champion

Also, come follow us at https://www.linkedin.com/company/spartabi
🙂

Sure doing it right away !

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors