How to add an average amount to a slicer?

[Anonymous]

I have a table in which I count the number of contracts sold per destination, number of days of the contract, subcriber gender, number of benificiaries and number of vehicles. In this table the total premium for these contracts is also shown, as well as the average premium (which is a metric that sums the total premium grouped per destination and divided by the number of contracts).

I would like to add a slicer to the report page to filter on the average premium (AverageBasketPremium). This is not possible as this value is based on a measure. 

Any suggestions on how to resolve this?

[Anonymous]

Hi @v-henryk-mstf ,

The only filter for premium gross is that should be more than 0.

I would like to add a slider with a minum of the lowest average basket (in my example 10) and a maximum of the highest average basket (in my example 18).

Is it due to the fact that the AverageBasketPremium is a measure that I cannot use it in the slicer? If so, are there any workarounds?

Best regards,

Jos

[v-henryk-mstf]

Hi @Anonymous ,

According to your description, what are the filter conditions for average premium? Can you provide a screenshot of the expected result so that I can answer it for you as soon as possible?

Looking forward to your reply.

Best Regards,
Henry