Getting a SUM in a Matrix

[aflintdepm]

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.

[nandic · Accepted solution]

@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

[aflintdepm]

@nandic  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!