Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ...
Need Help
  • ddpl's avatar
    ddpl
    3 years ago

    Anonymous try this

    Measure = max(Yourtable[PlannedProcedureTime])
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Expected Result

istIDPlannedProcedureTime
7659120
764730
770060
ddpl's avatar
ddpl
Solution Sage
3 years ago

Anonymous try this

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi thanks - but can we do this as a meseaure as i need to use it for other visuals and metrics. please.

    • ddpl's avatar
      ddpl
      Solution Sage
      3 years ago

      Anonymous try this

      Measure = max(Yourtable[PlannedProcedureTime])