Use of filter condition in countrows when condition can be blank

[mattbarker]

I have a user slicer and a matrix table of values populated by a series of countrow conditions. I would like the table to be affected by the user selection but the user selection can also be blank, meaning "all".

I have tried including the selected user in the filter condition but as this appears blank when no user is selected, the filter does not bring back the correct number of rows.

Question. How can I handle a blank filter condition?

VAR CurrentStatus = SELECTEDVALUE('opportunities'[StepNameNumber])

VAR CurrentUser = SELECTEDVALUE('opportunities'[_owninguser_value])

VAR ThisStep =

COUNTROWS(

FILTER(

ALL('opportunities'),

'opportunities'[wvnz_processtype]=783110002 &&

'opportunities'[StepNameNumber]=CurrentStatus &&

'opportunities'[_owninguser_value]=CurrentUser

)

)

Filters seem to work well when the conditions always return a value but it seems like I need the user condition in the filter to be ignored completely

.

[amitchandak]

@mattbarker , you can use isfiltered to check you have got some value of not

or try like

VAR CurrentStatus = values('opportunities'[StepNameNumber])

VAR CurrentUser = values('opportunities'[_owninguser_value])

VAR ThisStep =

COUNTROWS(

FILTER(

ALL('opportunities'),

'opportunities'[wvnz_processtype]=783110002 &&

'opportunities'[StepNameNumber] in CurrentStatus &&

'opportunities'[_owninguser_value] in CurrentUser

)

)

[mattbarker]

Hi @amitchandak,
Thank you. I will investigate isfiltered. You could please give me an idea of how it is used in this context?

You said "or try like" but I did not see any change to my DAX. Did you mean to recommend a change to my DAX?