Forum Discussion
Helper IIISum 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 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!
2 Replies
- amitchandak
Super User
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])
JLambs20Can 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?
