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 ...
Anonymous try this
Measure = max(Yourtable[PlannedProcedureTime])
Hi thanks - but can we do this as a meseaure as i need to use it for other visuals and metrics. please.
Anonymous try this
Measure = max(Yourtable[PlannedProcedureTime])