Sum of unique values for each row within the same category

[DawdF95Rze]

Hi all,

I have a problem with calculating the sum of unique values. I mean calculating the sum of the unique number of days in the question. Ultimately, the value 3+7= 10 should be output for each GUID within the same question

I use this DAX function:

Sum unique number of days for each row = CALCULATE(sumx(DISTINCT(Tabela[GUID]);FIRSTNONBLANK(Tabela[Number of Days];0));ALLEXCEPT(Tabela;Tabela[Term]))

but its not working, because its return Goal value only in the summary of the table not in the each row

GUID	Numer of days	Term	Respond	Question	Goal  value
324342	3	power bi	Kowalski	Sunrname?	10
324342	3	power bi	Nowak	Sunrname?	10
235236	7	c#	boniek	Sunrname?	10
235236	7	c#	Kowal	Sunrname?	10
235236	7	c#	Zelnik	Sunrname?	10

I need this solution in pivot table and DAX

[Greg_Deckler · Accepted solution]

Maybe:

Measure =

  CACLULATE(

    SUMX(

      DISTINCT('Table'[Numer of days])),

      [Numer of days]

    ),

    ALLEXCEPT('Table','Table'[Question])

  )