Combination of hasnofilter

[AndrejZitnay]

Hello Guys,

I have to HASNOFILTER OPTION

QuestionSelectCheck = IF(HASONEFILTER('Retention New / Used Table'[Old Type]),"New","Used")

QuestionSelectCheck2 = IF(HASONEFILTER('Retention Product Table'[Old agreement product]),"PCP","Non PCP")

Basically i have two slicers driving 4 visuals.

I need those visuals to be blank until one or other will be visible.

I can't use both at some time in visual level filters.

Is there way how to combine them to one if formula?

Many thanks.

Andrej

[Taamul90]

how can I raise a question? I want to post my qestion but I couldn't.

you can combine by adding ||  between the two of hasnofilter, but there is one condition to be applied.

*(|| = or)

[Eric_Zhang]

---

@AndrejZitnay wrote:

Hello Guys,

I have to HASNOFILTER OPTION

QuestionSelectCheck = IF(HASONEFILTER('Retention New / Used Table'[Old Type]),"New","Used")

QuestionSelectCheck2 = IF(HASONEFILTER('Retention Product Table'[Old agreement product]),"PCP","Non PCP")

Basically i have two slicers driving 4 visuals.

I need those visuals to be blank until one or other will be visible.

I can't use both at some time in visual level filters.

Is there way how to combine them to one if formula?

Many thanks.

Andrej

---

@AndrejZitnay

Bascially it is not possible. There're might be some workaround using tricky measures, please post more details like sample data, expected output etc to have a better understanding on your scenario.

[AndrejZitnay]

Hello @Eric_Zhang

Thank you for your clarification.

I will try to find out something else.

I think that I will use Bookmarks Pane & Selection Pane.

Effectively I need to hide some figures and with bookmarks I can hide whole selection rather than just some numbers.

Thank you .

Kind regards.

Andrej