Forum Discussion

HPax's avatar
HPax
Frequent Visitor
1 year ago
Solved

Display column total on measure value

Hi all, I am new to Power BI and can't seem to display the totals on my matrix for each column. Hoping someone can help!    My matrix has (3) columns. The 1st is a quick measure, the 2nd is a custo...
"Calculated Column"
CUSTOMCOLUMN
sub totals
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi HPax ,

     

    Have you tried SUMX?

    Count of Completed Training = SUMX('Training Tracking',CALCULATE(COUNTROWS(FILTER('Training Tracking', SELECTEDVALUE('Training Tracking'[Training Topic - Levels]) = 'Training Tracking'[Training Topic - Levels] && SELECTEDVALUE('Current Employee Names'[Employee Name]) = 'Training Tracking'[Trainee]))))

    If the above DAX does not work, please provide sample data or a pbix file(exclude sensitive data).

     

     

     

     

    ——————————————————————————————————————————————————

    If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.

     

    Best regards,

    Mengmeng Li

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi HPax ,

 

Have you tried SUMX?

Count of Completed Training = SUMX('Training Tracking',CALCULATE(COUNTROWS(FILTER('Training Tracking', SELECTEDVALUE('Training Tracking'[Training Topic - Levels]) = 'Training Tracking'[Training Topic - Levels] && SELECTEDVALUE('Current Employee Names'[Employee Name]) = 'Training Tracking'[Trainee]))))

If the above DAX does not work, please provide sample data or a pbix file(exclude sensitive data).

 

 

 

 

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.

 

Best regards,

Mengmeng Li

 

 

HPax's avatar
HPax
Frequent Visitor
1 year ago

That worked! Thank you so much! I had tried Sumx previously, but nested the formulas incorrectly.

 

But this does create a new issue for me. Since the column is counting duplicates, the % complete totals are artificially inflated. I was able to solve this on my own using the following. 

 

Created a column using the below: 

 

Unique/Repeat = RANKX(FILTER('Training Tracking', 'Training Tracking'[Trainee] = EARLIER('Training Tracking'[Trainee]) && 'Training Tracking'[Training Topic - Levels] = EARLIER('Training Tracking'[Training Topic - Levels])), [Date],, ASC, Dense)

 
Then added this condition onto my previous formula.
 
Count of Completed Training = SUMX('Training Matrix', CALCULATE(COUNTROWS(FILTER('Training Tracking', SELECTEDVALUE('Training Tracking'[Training Topic - Levels]) = 'Training Tracking'[Training Topic - Levels] && SELECTEDVALUE('Current Employee Names'[Employee Name]) = 'Training Tracking'[Trainee] && 'Training Tracking'[Unique/Repeat] = 1))))

 

Thanks again!