How to show the Sum of the total column in the Matrix Table
Hi PBI Community,
I created a measure to divide one table column from another table column. I used this code:
Coach Requirement = var headcount = CALCULATE(SUM(Forecast[Forecast])) var cratio = CALCULATE(SUM(Ratio[Coach Ratio]),FILTER(Forecast,Forecast[Account with LOB]=RELATED(Ratio[Account with LOB]))) Return DIVIDE(headcount,cratio)
My problem is when I used this in the matrix table, it's also dividing the total (I think). Is there a way to change the Total showing in the Matrix to sum just like when we use Pivot in Excel?