Forum Discussion
aflintdepm
2 years agoHelper III
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 ...
- 2 years ago
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
nandic
2 years agoResident Rockstar
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
- aflintdepm2 years agoHelper III
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!