Forum Discussion
Kopec
Helper I
Helper ISum the Unique values to appropriate value
Can anybody help me with this:
Sum the unique values in column "B" to the appropriate value in column "A". Thank you, Jan
Kopec - You can use the below to get your desired answer (just change the column names):
VAR _table = SUMMARIZE( 'Table', 'Table'[Column1], 'Table'[Column2] ) RETURN SUMX( _table, 'Table'[Column2])If this works for you please accept as the solution to help others with the same challenge.
Hi Kopec
The formula i offered can work in power pivot.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
KopecHelper I
Helper IIt's almost done, but I need:
SUMX (
VALUES ( 'Table'[Column B] ),
'Table'[Column A]
)In Column "A" is string.... I have got a mistake. I suppose because of that STRING values in Column A.
Can you help me?
mark_endicott
Super User
Super UserKopec - You can use the below to get your desired answer (just change the column names):
VAR _table = SUMMARIZE( 'Table', 'Table'[Column1], 'Table'[Column2] )
RETURN
SUMX( _table, 'Table'[Column2])
If this works for you please accept as the solution to help others with the same challenge.