cancel
Showing results for
Did you mean: Regular Visitor

## 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])))

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. 😊

1 ACCEPTED SOLUTION  Community Support

Hi @Carlo_V ,

Take a look at ISINSCOPE() function.

You could create a new measure like below:

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

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.  Community Support

Hi @Carlo_V ,

Take a look at ISINSCOPE() function.

You could create a new measure like below:

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

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.   