How to show the Sum of the total column in the Matrix Table

[Anonymous]

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?

Thanks so much for the assistance. 😊

[Anonymous · Accepted solution]

Hi @Anonymous ,

Take a look at ISINSCOPE() function.

https://docs.microsoft.com/fr-fr/dax/isinscope-function-dax 

You could create a new measure like below:

Measure = IF(ISINSCOPE([column]),[Coach Requiremen],sumx('table',[Coach Requiremen]))

Best Regards,

Jay