Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

remove a column filter in the sumx

Hi All,

 

I have the following dax:

SUMX(  
    SUMMARIZE(
    FILTER('Agent','Agent'[INS]=1),
    [policy_num],"value",MAX('Agent'[count])),     
    [value])

Now I want to add ALL('Aagent'[type]) to remove the interactions with type slicers. How can I get it?

Thanks in advance!

Need Help

2 Replies

  • PabloDeheza's avatar
    PabloDeheza
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hi Anonymous !
    Try the following:

    SUMX(
    SUMMARIZE(
        FILTER( ALL( 'Agent' ), 'Agent'[INS] = 1 ),
        [policy_num],
        "value", MAX( 'Agent'[count] )
    ),
    [value]
)

    Let me know if that helps!

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi PabloDeheza ,

       

      It doesn't work. I only want to remove the interaction of 'Agent'[type] but not the whole ''Agent''.