- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

How do i solve for Employee Count is linked to Department, Section and Sub Section
Hi Guys, i need help as you can see the Total Actual for every row is the same 3606. Is there any way to solve it where the figures is according to the department, section and subsection just like the Total Plan column.
For my Total Plan column is it manually inputted based on the excel file.
For the Total Actual column is taken from another excel file. What i did for Total Actual is input DAX formula:
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
The mostly is the relationship between these table. you should make sure that these tables have active relationship between them, then you can just use the measure which looks like you provided.
Or please modify the measure like the code below:
MJK Employee Count =
COUNTROWS(
FILTER(
ALL( 'MJK Total Employees' ),
'MJK Total Employees'[Department]
= SELECTEDVALUE( 'this table Employees'[Department] )
&& 'MJK Total Employees'[Section]
= SELECTEDVALUE( 'this table Employees'[Section] )
&& 'MJK Total Employees'[Sub Section]
= SELECTEDVALUE( 'this table Employees'[Sub Section] )
)
)
The link to your pbix is not accessible.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Anonymous ,
The mostly is the relationship between these table. you should make sure that these tables have active relationship between them, then you can just use the measure which looks like you provided.
Or please modify the measure like the code below:
MJK Employee Count =
COUNTROWS(
FILTER(
ALL( 'MJK Total Employees' ),
'MJK Total Employees'[Department]
= SELECTEDVALUE( 'this table Employees'[Department] )
&& 'MJK Total Employees'[Section]
= SELECTEDVALUE( 'this table Employees'[Section] )
&& 'MJK Total Employees'[Sub Section]
= SELECTEDVALUE( 'this table Employees'[Sub Section] )
)
)
The link to your pbix is not accessible.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello Chenwuz,
i just realised when i use your code, it is not showing the Total at the bottom. How can i solve this issue?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

It works, thank you so much. But can you explain what is your code doing?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Can i ask what is the: 'this table Employees'
= SELECTEDVALUE( 'this table Employees'[Department] )
This is the result i get seems to be correct, and how do i show the grand total at bottom For eg.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

These are what i have done in the PBI Report.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous , can you share a .pbix file?
It seems that you have 2 tables showing data from 2 files. Are these tables connected? It looks like not...
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

They have similar columns which can be linked to each other. I have uploaded a sample of the excel files and PBI Report. Please take a look. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous , something is wrong with an access:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.
Check out my latest demo report in the data story gallery.
Stand with Ukraine!
Here are official ways you can support Ukraine financially (accounts with multiple currencies):
1) Support the Armed Forces of Ukraine: https://bank.gov.ua/ua/about/support-the-armed-forces
2) Come Back Alive foundation: https://www.comebackalive.in.ua/
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

You mean, you cant open the PBI file?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hey,
as mentioned "
For the Total Actual column is taken from another excel file. What i did for Total Actual is input DAX formula:
Please share the model for this that you have in place.
If MJK Total EMployees is not filtered by department, section, subsection then this would also not reflect in the table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

2 Excel files:
PBI Report
https://drive.google.com/file/d/1-7wkA8geVHPi3ZsUG9gpS21a5lB81tKd/view?usp=sharing
Look at the table sheet and the model tab
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Based on the above image, under the sub section 2F cutting, the total plan is 116, whereas the total actual is 3606. There should be 100+ of workers under this 2F and 20 workers under 2F distribution.
If you see the table clearly, the value of 3606 appears the same for every subsection. Therefore, i want to know is there a way to solve it.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-11-2024 05:34 AM | |||
10-17-2024 11:35 AM | |||
12-13-2024 07:00 AM | |||
12-19-2024 05:50 AM | |||
11-06-2024 08:35 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
61 | |
46 |