Forum Discussion
percentage from total
This has actually helped. Now resolved.
Hi AlB ,
I used your formula and it worked like a charm.
do you think there's a way to make the (ALL(Table1)) part filter or axis?
I used this formula for my Employee engagement survey and i need to filter by question, country, age bracket and department.
so i need percent of total where total will be all of the above depending on the filter or Axis i set
Thanks.
Community ChampionHi Anonymous
If you are using for instance country in the axis, something like this should do it
Measure = DIVIDE(SUM(Table1[Budget]), CALCULATE(SUM(Table1[Budget]), ALL(Table1[Country])))
Same patter for all the others. You can also, instead of a measure, just place the column Budget in Values of your chart and choose to Show value as -> Percentage of grand Total
I would recommend measures in general but if you have too many fields to use in the axis, the latter might be a quicker option
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers