Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dax help

Hi,

 

I am using this measure at the moment which is giving me all deals that are over 250k however it isnt showing them all as i have inlcuded the same data column but applied a filter instead.

Anyone know why it isnt including all the data?

 

Need Help
Show and Tell

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , This is a filter at line level. So you need at visual level mean after sum

     

    Assume you a category as a group by in visual

     

    Sumx(filter(pipleline, pipeline[Category], "_1", Sum(pipeline[Finance Amount])), [_1]>250000), [_1])

     

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    5 years ago

    Hi Anonymous 

     

    Sorry I don't understand your expected output. You want to show all rows of deals that are over 250k in the table visual? Or calculate the sum of all deals that are over 250k? Can you explain the output with some sample data?

     

    Regards,
    Community Support Team _ Jing