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 "CalculatedColumn".
Please refer the screenshot -
Hi,
Please check the below picture and the attached pbix file.
It is for creating a new column.
2 Replies
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.
