Forum Discussion
Matrix Percentage using Measures for Totals
Hi rlingua2234,
Although you have very limited information you need to make a measure that should look something like this:
% = ( SUM ( Table[01-Sales] ) + SUM ( Table[02-COGS] ) ) / SUM ( Table[01-Sales] )Then format as a percentage.
Concerning the second part what do you mean change it based on a slicer? What type of information as the slicer should have?
Regards
MFelix
Super UserHi rlingua2234,
Although you have very limited information you need to make a measure that should look something like this:
% =
( SUM ( Table[01-Sales] ) + SUM ( Table[02-COGS] ) )
/ SUM ( Table[01-Sales] )
Then format as a percentage.
Concerning the second part what do you mean change it based on a slicer? What type of information as the slicer should have?
Regards
MFelix
I have the formula for total but need it to also by branch.
This formula works for the totals
divide (sum ('BranchProfit Month'[Amount]),CALCULATE(sum('BranchProfit Month'[Amount]),'BranchProfit Month'[Main account category] = "01-SALES"))
But how do i group it by branch? Thanks so much