Subtracting from two difference tables

[christinas]

Hello. Thank you for your help in advance. I have two tables with the same columns on it for both; one is data for 2024 and one is for 2025. I am trying to find what information has changed between years based on the Job family (HR, IT, Sales, etc) and Job Level (IC, Mid Management, etc). For HR in 2024, the number of Individual Contributors (IC) was 106 but for 2025 it is 96. I have two measures, one for each year, to count the total number of records. 

Issue 1 - When I try and add either measure to the other years chart, it gives me the total and does not split it out to show the total by level; it gives the total for all levels. ex: if I add the measure from 2024 to the 2025 matrix table, it will show HR has 136 IC when it should say only 106.

Issue 2 - I would like to show the total difference between the levels. I created a measure to do this but it subractes the 2025 HR's IC by the total of 66 by the total for the 2024 HR of 136, not 106.

Below is the measure I created to fix issue 2.

Level Diff =

VAR LevelCount2024 = [Level Count 2024]

VAR LevelCount2025 = [Level Count 2025]

VAR ItemsWithDifference =

    ADDCOLUMNS(

        VALUES('2025 Employee Engagement'),

        "@LevelDifference", [Level Count 2024] - [Level Count 2025])

VAR CountedRows =

    COUNTROWS(ItemsWithDifference)

RETURN

    CountedRows

Any help is much appreciated. Thank you. 

[ryan_mayu · Accepted solution]

@christinas 

here is suggestion:

1. I think you need to create some dim tables (e.g. job family name table ) and connect dim table to these two fact tables.  Then in the matrix visual, the job family info should comes from the dim table.

2. Since you mentioned the tables with same columns. You can append tables in the power query

https://learn.microsoft.com/bs-latn-ba/power-query/append-queries?wt.mc_id=DP-MVP-5004616

or do it by using DAX

https://learn.microsoft.com/en-us/dax/union-function-dax?wt.mc_id=DP-MVP-5004616

If these two approahes still does not work for you, pls provide some sample data and expected output.

[christinas]

Thank you, @ryan_mayu . I think that may work.

[ryan_mayu]

you are welcome

[Ashish_Mathur]

Hi,

Share the download link of the PBI file or share some dummy data to work with.