Forum Discussion

eakeekkk's avatar
eakeekkk
Frequent Visitor
4 years ago

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...
Need Help
eakeekkk's avatar
eakeekkk
Frequent Visitor
4 years ago

It seem matrix visual is filtered by filter's id of parrent is there anyway to disable filter in row or column of visual

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi eakeekkk 

     

    Try this measure

    sum value =
VAR CurrentEmployeeID =
    SELECTEDVALUE ( 'Member'[ID] )
RETURN
    CALCULATE (
        SUM ( 'Member'[Value] ),
        ALL ( 'Member'[ID], 'Member'[Path] ),
        PATHCONTAINS ( 'Member'[Path], CurrentEmployeeID )
    )

     

    Or if you don't want the slicer to filter the matrix visual, you can select the slicer, go to Format > Edit interactions. Disable the slicer from filtering the matrix visual. Reference: Change how visuals interact in a Power BI report 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.