Forum Discussion
How to add calculated column in table visualization based on row data on table visualization
I need to know how to add a new calculated column that shows the value of sum of values divided by sum of vlaues for each row separately
This table is designed to filter the project phases as per the available records in the column of project phases which is dynamic values
I have tried these solutions,
to add a calculated column in the data table But it will lead to a value for each record and the sum of these values is not the same as total divided by total for each project phase
Also, calculated measures didn't work because the phases are dynamic in numbers and value
Are there other options similar to what is available in SSRS table values
I searched on the Internet,
The solution is to create a new table using the Summary function,
to summarize and group the project phases, or any specific column or columns,
parent grouping, and parent-child groups in SSRS,
then add columns with a sum function to calculate the sum of values for each group,
then add a calculated column to apply functions on each row,
The result is as follows
3 Replies
Ahmad_16 no idea what you are talking about. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490thanks
I searched on the Internet,
The solution is to create a new table using the Summary function,
to summarize and group the project phases, or any specific column or columns,
parent grouping, and parent-child groups in SSRS,
then add columns with a sum function to calculate the sum of values for each group,
then add a calculated column to apply functions on each row,
The result is as follows
