cancel
Showing results for
Did you mean:
Regular Visitor

## Display total of all respective columns in Table visual.

Hi All,

As seen in above screen shot I am able to display total of last column only in a Table. My requirement is like I want to display total of actual contribution% and _FTE.

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: Display total of all respective columns in Table visual.

I have an ex with Salary and % Salary of Employee. You can try this step by step:

1. Create a Column "Total Salary" = SUM(Employees[EmployeeSalary])
2. Create Measure "Sum Salary" =  CALCULATE(SUM(Employees[EmployeeSalary]))
3. Create Measure "% Salary" = CALCULATE  ( DIVIDE([sum Salary] , VALUES(Employees[Total Salary])))

If you got some problem, delete some data and upload your pbix file. I can solve directly on your pbix file.

Regards,

ManNVSM.

10 REPLIES 10
Senior Member

## Re: Display total of all respective columns in Table visual.

Make sure your column has a default summarisation under the modelling tab.

However with % calcs it may be better to have a measure that works correctly at all levels. Measures should total automatically.

Super Contributor

## Re: Display total of all respective columns in Table visual.

The contribution% is a measure in your table visual? What's your formula and resouce table look like? Please share more details for further analysis.

Best Regards,
Angelia

Regular Visitor

## Re: Display total of all respective columns in Table visual.

I have a column in my actual table namely Actual Contribution % . I just dragged and drop this column in a Table visual along with other two columns as shown in screenshot. Then just by enabling Total function of Table visual , I get count of _FTE column and displayed respective count. But when same thing I am trying to do with Actual Contribution % column then I am not able to get respective count over there. And suppose I am taking COUNT( Actual Contribution %) after removing count functionality of _FTE then I am able to get count of actual contri%.

So now my actual issue is like I want to dispaly respective counts of both columns . But at a time I am getting count of only 1 column.

Hope now you will understand my main problem.

Regards,

Regular Visitor

## Re: Display total of all respective columns in Table visual.

Hi @stretcharm,

I need to show count of actual contri % in a place of red mark..

Is it possible to add measure value in table visual where I marked red circle?

Regards,

Senior Member

## Re: Display total of all respective columns in Table visual.

What data type? Is it Text is the % part of the value? What is default summarization is there in the modelling tab.

Text fields set to Do not summarise don't show totals.

If your data is summarised already to get each row then you have to use the same type of summarisation on the total.

Try creating a computed column or measure that does the same value and see if that works.

Highlighted
Regular Visitor

## Re: Display total of all respective columns in Table visual.

For % part data type is percentage and default summarization is set to don't summarised.

Now I can am able to get count of Actual contri %. but instaed of 0.00% I am getting 1 in front of each project in a table.

So can we get index numbers like 1,2,3,4..... etc instead of 1 1 1??

Super Contributor

## Re: Display total of all respective columns in Table visual.

The total value is based on the calculation of each rows above, you want to getting running total right? Could you please share your data table in table format rather than screenshot, and list the expected result, so that we can copy data and try to reproduce.

Best Regards,
Angelia

Member

## Re: Display total of all respective columns in Table visual.

I have an ex with Salary and % Salary of Employee. You can try this step by step:

1. Create a Column "Total Salary" = SUM(Employees[EmployeeSalary])
2. Create Measure "Sum Salary" =  CALCULATE(SUM(Employees[EmployeeSalary]))
3. Create Measure "% Salary" = CALCULATE  ( DIVIDE([sum Salary] , VALUES(Employees[Total Salary])))

If you got some problem, delete some data and upload your pbix file. I can solve directly on your pbix file.

Regards,

ManNVSM.

Super Contributor