Calculated column in output table

[PowerRobots99]

Hello Friends,

May i know how to calculate a column in output table such that it should filter each category in the input table, take sum of corresponding values and giver result in "CalculatedColumn".

Please refer the screenshot -

[rajendraongole1]

Hi @PowerRobots99 - You can achieve this using a measure  as below instead of calculated column

Total Value by Category =

CALCULATE(

    SUM('inpu'[Value]),

    ALLEXCEPT('inpu', 'inpu'[Categoryname])

)

Hope it works.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.