Forum Discussion

JLambs20's avatar
JLambs20
Icon for Helper III rankHelper III
3 years ago

Sum of a Column from a Distinct Row

Hello,   I'm having trouble figuring out the DAX for my issue here.  My table has a ROW ID column that has some duplicate numbers due to splitting column/unpivoting data.  Everything about the data...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

JLambs20 , For that you need to finalize a level let say 'Spli List'[user]

 

then you can create a measure using your old measure

 

sumx(Values('Spli List'[user] ),[Your measure])

  • JLambs20's avatar
    JLambs20
    Icon for Helper III rankHelper III
    3 years ago

    Can you expand a bit on what you mean by "finalize a level"? As for the measure you added, would I not want to use the column that has the hours associated instead of the user's name?