Forum Discussion
Getting a SUM in a Matrix
I have a set of data that I have to trend by date. The data is formatted as follows:
| Date | Visit Type | Total Completed |
| 5/24/24 | New | 4 |
| 5/24/24 | Follow-Up | 3 |
| 5/24/24 | Discharge | 1 |
| 5/25/24 | New | 3 |
| 5/25/24 | Follow-Up | 2 |
| 5/25/24 | Discharge | 2 |
The "Total Completed" column is already a total, so I don't need to do any calculations on this value individually.
My desired output is a matrix that looks like this:
| Visit Type | 5/24/24 | 5/25/24 | Total |
| New | 4 | 3 | 7 |
| Follow-Up | 3 | 2 | 5 |
| Discharge | 1 | 2 | 3 |
I wrote the following measure as my starting point:
Visits by Type = CALCULATE(SUM('Table1'[Total Completed]), ALLEXCEPT('Table1','Table1'[Visit Type]))
When I do this, my output looks like this:
| Visit Type | 5/24/24 | 5/25/24 | Total |
| New | 7 | 7 | 7 |
| Follow-Up | 5 | 5 | 5 |
| Discharge | 3 | 3 | 3 |
What am I missing to get the values to distribute by day and only sum for the total?
Thank you for your help.
aflintdepm would it be fine if you used matrix visual?
It would return desired output, without any dax calculation. Correct me if i misunderstood the issue.
Cheers,
Nemanja Andic
2 Replies
aflintdepm would it be fine if you used matrix visual?
It would return desired output, without any dax calculation. Correct me if i misunderstood the issue.
Cheers,
Nemanja Andicnandic That's what I was expecting to be able to do, but for some reason, the matrix would now allow me to select sum- it kept forcing count or distinct count. This morning when I re-opened the workbook file, SUM was an available option. Guess it was just glitchy. Thank you for your help!
