Forum Discussion
Sum child under parent issue
Hi Folks, My requirement is to sum all child value under slicer filter parrent id seperate by other column eg. sex, position. My DAX code is correct when show in card visual but when show in metr...
Now I'm already finish this requirement by create another distinct ID table and use this table as a slicer.
Here is my measure
sum value =
VAR CurrentEmployeeID = CALCULATE(SELECTEDVALUE('DimID'[ID]),ALLEXCEPT('DimID','DimID'[ID]))
RETURN
CALCULATE (
sum('Member'[Value]),
ALL( 'DimID'[ID] ),
PATHCONTAINS ( 'Member'[Path], CurrentEmployeeID )
)