Forum Discussion
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. A...
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])