Forum Discussion
Advocate IDax for matrix table
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
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
2 Replies
- Shahid12523
Community Champion
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 
Kay_KaluThanks this has worked