sdhnResponsive Resident5 years agoSolvedCalculate % Hi All, I have a table with two columns. City Profit Chicago 60 Los Vegas 80 New York 40 Los Angeles 90 Houston 10 Total Profit 280 I need to add one more ...Show MoreFrankAT5 years agoHi sdhn , you can do it like this: Sum of Profit = SUM('Table'[Profit]) Percentage = DIVIDE([Sum of Profit],CALCULATE([Sum of Profit], ALL('Table'))) With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at homeFrankAT (Proud to be a Datanaut)
FrankAT5 years agoHi sdhn , you can do it like this: Sum of Profit = SUM('Table'[Profit]) Percentage = DIVIDE([Sum of Profit],CALCULATE([Sum of Profit], ALL('Table'))) With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at homeFrankAT (Proud to be a Datanaut)
FrankAT5 years agoHi sdhn , you can do it like this: Sum of Profit = SUM('Table'[Profit]) Percentage = DIVIDE([Sum of Profit],CALCULATE([Sum of Profit], ALL('Table'))) With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at homeFrankAT (Proud to be a Datanaut)
FrankATCommunity Champion5 years agoHi sdhn , you can do it like this: Sum of Profit = SUM('Table'[Profit]) Percentage = DIVIDE([Sum of Profit],CALCULATE([Sum of Profit], ALL('Table'))) With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at homeFrankAT (Proud to be a Datanaut)
Related contentMoM calculationCalculation HelpCalculate TooltipsHour CalculationCalculating with Filters
