Forum Discussion

silaz's avatar
silaz
New Member
8 years ago
Solved

table object ad new filtered measure

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.

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support

    Hi silaz,

     

    Please change ALL() function to ALLSELECTED(). 

     

    Best Regards,
    Qiuyun Yu