Calculate selected value in slicer

[hanami001]

Dear All,

I have created the measure for calculating value. I want when I selected value (multiple selections) the measure should be calculated only field selected. please advise me.

For example, I select PG Class Y, M,...,Q, I want measure AV-Fare Forecast INL to calculate only selected Y, M,...,Q.

[v-piga-msft]

Hi @hanami001,

As I know, if you create the measure that could achieve your requirement but you' better not use ALL function the to filter the whole table, otherwise the selected value in the slicer will not affect the measure.

If it is convenient, could you share some data sample or your desired output so that we can help further on it?

Best Regards,

Cherry