Forum Discussion

browna6's avatar
browna6
Frequent Visitor
2 years ago
Solved

Sum up the difference between two times as a numeric value

Hi   I have sample data where i am trying to summarise by Area and show the minimum time and the maximum time in each area. Then show the difference between to two times to give me the Total Hours/...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  browna6 ,

     

    You can try the following measureļ¼š

    Measure =
var _table=SUMMARIZE('Table','Table'[Area],"Value",[Hours])
return
IF(
    HASONEVALUE('Table'[Area]),[Hours],SUMX(_table,[Value]))

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

browna6 First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8