Forum Discussion
Sum or Sumx based in distinct count another column same table
Hi Expert
Need a dax measure to give me the distinct count based in ListID and the sum of the PlannedProcedureTime
see sample data
| ListID | PlannedProcedureTime |
| 7659 | 120 |
| 7659 | 120 |
| 7647 | 30 |
| 7647 | 30 |
| 7700 | 60 |
| 7700 | 60 |
| 7700 | 60 |
| 7700 | 60 |
| 7700 | 60 |
Anonymous try this
Measure = max(Yourtable[PlannedProcedureTime])
