Dax for matrix table

[Kay_Kalu]

I have this table image below 

Lookin to create a matrix table below 

Total Checking Parent Count = Distinct count of unique checking_parent/JIRA_ID where the checking parent matches the "Checking Parent" column on this table

Total SQL Feedback = ( (Distinct count of unique checking_parent/JIRA_ID/feedback category = "SQL" /Item_ref where the checking parent matches the "Checking Parent" column on this table) 

Total SQL No Feedback = ( (Distinct count of unique checking_parent/JIRA_ID where the checking parent matches the "Checking Parent" column on this table) * (SQL Weighting for the "Checking Parent" colmun in the "Task Weighting" tab) ) - Minus cases from the "Total Feedback" column

I have been able to sort out Total Checking Parent Count and Total SQL Feedback from my previous post Just cant figure out how the lookup the value form Task weighting table. more context below

TotalSQLFeedback i haven't explained it well so below is a sample explained. thanks

jira_id	item_ref	comment_date	checking_parent	feedback category
PPDQ-9506	PR1	18/07/2025 16:52	Population Review Check	SQL
PPDQ-9387	PR1	01/07/2025 16:17	Population Review Check	SQL
PPDQ-9387	PR2	01/07/2025 16:17	Population Review Check	SQL
PPDQ-9350	PR1	16/06/2025 17:24	Population Review Check	SQL
PPDQ-9225	PR1	20/05/2025 17:21	Population Review Check	SQL
PPDQ-9225	PR1	01/07/2025 13:54	Population Review Check	SQL

From the table above I have filtered the feedback category = "SQL" and checking_parent = Population Review Check then the count to get Total SQL Feedback will be distinct count of Item_ref in relation to the jira_id. e.g PPDQ-9387 will count as 2 but PPDQ-9225 will count as 1- Thiis have be solved then this below is the issue

Total SQL No Feedback = ( (Distinct count of unique checking_parent/JIRA_ID where the checking parent matches the "Checking Parent" column on the first table) * (SQL Weighting for the "Checking Parent" colmun in the "Task Weighting" table beow ) - Minus cases from the "Total Feedback" 

If I could be helped with DAX for this calculation it will help.

Checking Parent	SQL Weighting	Business Weighting	Process Weighting
Population Review Check	3	2	7
Data Fix Driver File Checking	1	2	3
P&C Request Checking	0	1	4
CS/Suspense Handover Checking	1	0	5
Bespoke Datafix Spec Checking	0	0	4
Sweep Docs Checking	2	3	3
Review Signoff	2	0	6
Calc Flag Review Signoff	2	0	5
Totals	11	8	37

Attached is the Task Weighting table. so it uses the weight "SQL Weighting" when the iteam_ref is SQL and so on. the checking_parent will be row filtered 

[Kay_Kalu]

Thanks this has worked

[Shahid12523 · Accepted solution]

Total SQL No Feedback =
VAR Parent = SELECTEDVALUE('FeedbackData'[checking_parent])
VAR JiraCount = CALCULATE(DISTINCTCOUNT('FeedbackData'[jira_id]), 'FeedbackData'[checking_parent] = Parent)
VAR SQLWeight = LOOKUPVALUE('TaskWeighting'[SQL Weighting], 'TaskWeighting'[Checking Parent], Parent)
RETURN (JiraCount * SQLWeight) - [Total SQL Feedback]

✅ Counts distinct JIRA_IDs per Checking Parent
✅ Multiplies by SQL Weighting from TaskWeighting
✅ Subtracts your existing Total SQL Feedback measure