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 😀