RATING WISE EMPLOYEE COUNT

[PRADEEPJAAN]

Hii Guys,
       I have one challange in my project.I want emp Rating wise emp count. If am select rating 1 in slicer i want to show in  card that show emp count of rating 1 employees.
Here is the sample data

EMP CODE	RATING
1001	1
1002	2
1003	1
1004	5
1005	3
1006	2
1007	4
1008	5
1009	1
1010	4
1011	3

[pradeepnani]

Hi, 
to achieve the rating wise count you can use this measure 

Rating Wise count=
var select=selectedvalue(tablename[rating])
var result=If(select,calculate(tablename[employee code]))
return
result

[grazitti_sapna · Accepted solution]

Hi @PRADEEPJAAN,

You can achieve this by creating a DAX measure that counts the number of employees based on the selected rating in the slicer.

Solution: Create a Measure

Use the following DAX formula:

Emp Count by Rating = 
VAR SelectedRating = SELECTEDVALUE('Table'[RATING])
RETURN 
CALCULATE(
COUNT('Table'[EMP CODE]),
'Table'[RATING] = SelectedRating
)

Steps to Implement:

1. Load your data into Power BI.
2. Create a slicer using the RATING column.
3. Create a card visual and apply the Emp Count by Rating measure.
4. Now, when you select a rating in the slicer, the card will show the count of employees with that rating.

Expected Output:

• Selecting Rating = 1 in the slicer → The card will show 3 (employees: 1001, 1003, 1009).
• Selecting Rating = 2 → The card will show 2 (employees: 1002, 1006).
• And so on…

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!