Filter textbox value depending on multiple filter

[Avian65]

I have screated measure i.e. TotalMachine (TotalMachines = Count(Machine[Id])). It is showing correct count. I added this value in textbox. I also have one dropdown filter ion year. I want that when user select single or multiple from year dropdown. Text box should also ipdate accordingly. I have 4-5 other filters, text box value should update accordingly.

Please let me know what is the best way to do it.

Avian

[v-yanjiang-msft · Accepted solution]

Hi @Avian65 ,

According to your description, when the measure is calculated, if the interaction between visuals are not turned off, it will automatically be effected by the other slicers, no additional steps are required.

I create a sample and a measure like yours.

The measure changed by the value selected in the slicers.

If your file is more complex and it doesn't work, please explain more about your sample.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HoangHugo]

Hi

Just add fields into Slicer to make filter you want. Make sure all fields have relation with Machine [ID] (like they are in same table, or they have one-to-many relationship)

[Avian65]

Can you tell me how to do it? I tried it, but it seems is not working for me.