table object ad new filtered measure

[silaz]

I've created a new measure with 'all' filter:

NewMeasure= CALCULATE(SUM('table'[field1]);all(table[field2]))

If i use this measure in a table object and I apply a value for field2 in a slicer,
the table correctly displayed the filtered records but the sum of NewMesure is not calculated correctly,

The sum takes into account unfiltered data.

[v-qiuyu-msft · Accepted solution]

Hi @silaz,

Please change ALL() function to ALLSELECTED(). 

Best Regards,
Qiuyun Yu