Forum Discussion
Helper ISum the Unique values to appropriate value
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.
Hi,
Thanks for the solution mark_endicott and DataNinja777 offered, and i want to offer some more information for user to refer to.
hello Kopec , mark_endicott 's solution is right, you can use it as a calculated column .
Column =
VAR a =
SUMMARIZE ( 'Table', [Column1], [Column2] )
RETURN
SUMX ( FILTER ( a, [Column1] = EARLIER ( 'Table'[Column1] ) ), [Column2] )
Output
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.
Helper IHi,
for Power BI it works great.
Can anybody help me how to make it work in Power Pivot?
And can anybody know, why the below formula doesnt work?
=CALCULATE (SUMX(TABLE; Column B);VALUES(Column B); ALLEXCEPT(TABLE; Column A)
)
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.