Forum Discussion

PVO3's avatar
PVO3
Impactful Individual
5 years ago
Solved

Order of FILTER function

Good day,   I'm looking for some DAX help.  Edit: added sample    My model looks like: Customer *→1 Bridge 1←* Actions Product *→1     So note the facts (actions) are connected...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Please try:

    Filter combination = 
VAR _filter1 = [Filter 1]
var _filter2 = [Filter 2]
return IF(ISBLANK(_filter2),_filter1,_filter2)

     

PVO3's avatar
PVO3
Impactful Individual
5 years ago

Nobody? Hoping this was an easy fix because I overlooked something.

V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Please try:

Filter combination = 
VAR _filter1 = [Filter 1]
var _filter2 = [Filter 2]
return IF(ISBLANK(_filter2),_filter1,_filter2)

 

  • PVO3's avatar
    PVO3
    Impactful Individual
    5 years ago

    Great, thanks a lot! Just the addition of the IF(ISBLANK, will end my sleepless nights.

    Such a simple solution which makes me feel stupid 😀