topic Re: Display Rollup Total at Row Level - Matrix Visual in DAX Commands and Tips

Display Rollup Total at Row Level - Matrix Visual

Standish — Fri, 04 Mar 2022 14:10:20 GMT

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.

Re: Display Rollup Total at Row Level - Matrix Visual

amitchandak — Fri, 04 Mar 2022 17:11:50 GMT

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.

Re: Display Rollup Total at Row Level - Matrix Visual

v-xiaotang — Tue, 08 Mar 2022 06:20:34 GMT

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.