Forum Discussion

TomSinAA's avatar
TomSinAA
Icon for Helper IV rankHelper IV
2 years ago
Solved

Totals in Matrix

I am trying to get the totals correct for the Expected Learner column in the matrix below   The source table has a row for each learner and Expected Learners has the same value for all learne...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi TomSinAA ,

    _AAndrade Thanks for your concern about this case!

    And TomSinAA , it seems that the Expected Learners is a measure, right?
    If it is, this is my sample DAX:

    Expected Learners = MAX('Table'[Expected])


    And please try to add this DAX:

    Measure = SUMX(VALUES('Table'[Region]), [Expected Learners])

    The final output is as below:

     

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi TomSinAA ,

_AAndrade Thanks for your concern about this case!

And TomSinAA , it seems that the Expected Learners is a measure, right?
If it is, this is my sample DAX:

Expected Learners = MAX('Table'[Expected])


And please try to add this DAX:

Measure = SUMX(VALUES('Table'[Region]), [Expected Learners])

The final output is as below:

 

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.