Hierarchy Level Totals in Matrix Visual

[Vikas_Mattela]

Hey Folks,

I have created a matrix visual by using 4 levels of data (L1,L2,L3,L4). Now I want to calculate the % based on the Hierarchy level total in the matrix visual. I have tried DAX sing ISINSCOPE,ISFILTERED but both are not working.

[Anonymous]

Hi @Vikas_Mattela ,

Have a nice day. Has the issue been resolved?

Best Regards,

Wearsky

[Vikas_Mattela]

@lbendlin Thanks for your reply.

I have used below dax

HierarchySales =

VAR L1Col = CALCULATE(SUM(Sales[Amount]),ALLSELECTED(Sales[L1Column])

VAR L2Col = CALCULATE(SUM(Sales[Amount]),ALLSELECTED(Sales[L2Column])

VAR L3Col = CALCULATE(SUM(Sales[Amount]),ALLSELECTED(Sales[L3Column])

RETURN IF(ISINSCOPE(L1Column),L1Col ,IF(ISINSCOPE(L2Column),L2Col,L3Col)

But its showing same value as Amount column which is already there in Values section. By using above formula I want to calculate % of Hierarchy sales.

[lbendlin]

You need to test ISINSCOPE from the inside out, starting with L3.

[lbendlin]

ISINSCOPE is the right tool. Please explain what "not working"  means. What have you tried?