Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hierarchy Level Totals in Matrix Visual

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 ISI...
"DAX " "DAX help" 'Need help' 'DAX'
"Hierarchies"
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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