Forum Discussion

hanami001's avatar
hanami001
Frequent Visitor
8 years ago

Calculate selected value in slicer

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.

 

Need Help

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    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