Forum Discussion

Kay_Kalu's avatar
Kay_Kalu
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Dax 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 matc...
Need Help
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    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

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
1 year ago

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