Forum Discussion
Solved
Calculated column in output table
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 "CalculatedCo...
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new column.
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.