Dax help

[Anonymous]

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?

[v-jingzhang]

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

[amitchandak]

@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])