Filtering the filter by the value from the paratmeter

[Anonymous]

Hi all,
I have a dataset like that.

I created a what if parameter for increasing Plant filter option. I added 2 more option to filter (All and D&E Options).

 Also i have category filter.

Filtering to new Plant option don't affect category filter.

I want to solve this problem, but i couldn't find any solution.

PBIX File

Best regards

[v-cherch-msft]

Hi @Anonymous

It seems you may try to use 'Edit interactions' for category filter as below. Then the category filter will not affect the measure. If it is not your case, please explain more about your expected output.

Regards,

Cherie

[Anonymous · Accepted solution]

That's not my case.

I find an alternative solution.

I changed the calculation logic.

I created a new table instead of parameter and joined to my main table.

[v-cherch-msft]

Hi @Anonymous

Glad to hear you've solved it, please accept the solution to close this thread.

Regards,

Cherie