Sum of a Column from a Distinct Row

[JLambs20]

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 model is working well but since I do have those duplicate rows now, I have a column with numbers that are being summed incorrect (as one would expect with duplicate rows).  I have the DAX for counting distinct rows working find but I need to add the extra layer of "sum-ing" a column but only with distinct rows.  

Here is the formula for DISTINCTCOUNT that I'm using: 

So now I need to wrap a SUM formula in there for a column (call the column "hours") but make sure it's only "sum-ing" the hours in distinct rows. 

I'd appreciate any help!

[amitchandak]

@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]

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?