Display Rollup Total at Row Level - Matrix Visual

[Standish]

Hi, I have a data model as shown below.

I am trying to show a rollup of calls by employee.

The desired result would look like:

(#1) No Reporting Chain Level selected

(#2) Select Senior from Reporting Chain level slicer

See Jessica's calls and the sum of calls for all employees reporting into Jessica.
I'm defining an employee reporting into Jessica as Jessica being present in "ReportingChainLevel2" column in Employees table.

I have tried using a measure like below but it doesn't produce the desired result.

CALCULATE (
    SUM ('Employee Calls'[Num. Calls] ) ,
    ALLEXCEPT(ReportingChainLevels,ReportingChainLevels[ReportingChainLevel])
)

I'm open to all suggestions.

Thank you. 

[v-xiaotang]

Hi @Standish 

I've checked your expected result and it's possible to achievable. But we need a sample file to write the dax code, could you share it? Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Standish , refer if this can help

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.