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

Sorry to reply late already test this measure but it's return the same result don't have output for female

 

and in edit interaction regard to selectvalue for slicer and ignore interaction the output return blank 

 

Could you have other solution?

 

Thank you,

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

    Hi eakeekkk 

     

    Your measure is comparing 'Member'[Path] with the current member's id. Is a member possible to have both Male data and Female data in the data table? Can you provide some fake data to show the table structure and the expected output based on that data?

     

    Regards,

    Jing