My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Dax to calculate particular data in Power pivot|Power Pivot|Excel Forum|My Online Training Hub

You are here: Home / Dax to calculate particular data in Power pivot|Power Pivot|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Dax to calculate particular data in Power pivot
Avatar
Tarun Dhiman

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
October 17, 2020
sp_UserOfflineSmall Offline
1
October 17, 2020 - 2:29 am
sp_Permalink sp_Print

Hello everyone,

I am working on recruitment dashboard , In the attached file , on one sheet there is list of department wise opening and the second sheet there is list of candidates with remarks whether they are selected or not. By using DAX I want to calculate department wise hired employees. Some how I am not able to calculate it department wise it shows the grand total of hired in the last row.

Kindly help me in calculating hired employees department wise.

 

Thanks in advance,

Regards,

Tarun Dhiman

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4513
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
October 17, 2020 - 10:02 am
sp_Permalink sp_Print

Hi Tarun,

Welcome to our forum.

You don't need a measure for this. Build your PivotTable with the following fields:

 

Filters: Application Status - select 'Hired'

Rows: Department & Designation from Applications table

Values: Count of Job ID

 

Mynda

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Sherry Fox, Cassie Bernier
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 215
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Ngoc Qui Nguyen
Clement Mansfield
Rose .
Bindu Menon
Baruch Zemer
Purple RainbowBenefactor
MOTH Junkie
Forum Stats:
Groups: 3
Forums: 24
Topics: 6349
Posts: 27772

 

Member Stats:
Guest Posters: 49
Members: 32317
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen