Simultaneously conditional filter on two fields

[Kasiop]

Hi, I need your help... here is my issue: To display my result, I am using a table based on a direct query view but I have duplicate: line 1 title (filled), description (filled), formula (not filled) line 2 title (filled), description (not filled), formula (filled) My question: Can I use the filter panel to filter on both fields; formula is not blank AND description is not blank. If I don't do it simultaneously, I am ending up with only one line at a time. Thank you for your suggestions. N

[dedelman_clng]

Hi @Kasiop  - 

If I understand what you're trying to accomplish (show all records that have at least one of description or formula), you can create this calculated column, then use it in the filter pane and set to "Y":

Show =
IF (
    OR (
        AND (
            NOT ( 'Table'[Description] = "" ),
            NOT ( ISBLANK ( 'Table'[Description] ) )
        ),
        AND ( NOT ( 'Table'[Formula] = "" ), NOT ( ISBLANK ( 'Table'[Formula] ) ) )
    ),
    "Y",
    "N"
)

Hope this helps

David

[Greg_Deckler · Accepted solution]

@Kasiop - Create a measure like this:

Medida: IF(NOT(ISBLANK(MAX([formula]))) && NOT(ISBLANK(MAX([description])),1,0)

You can then filter by the measure.

[Kasiop]

Sadly is not working, I have an issue with () according to PBI

I used :

Measure 2 = IF(NOT(ISBLANK(MAX([solution]))) && NOT(ISBLANK(MAX([description])),1,0)) or

Measure 2 = IF(NOT(ISBLANK(MAX([solution]))) && NOT(ISBLANK(MAX([description])),1,0)

and I have an error in both "Operator or expression () is not supported"

[dedelman_clng]

You need a 3rd close paren after [description]

... NOT ( ISBLANK ( MAX ( [description] ) ) ),1, 0)

Hope this helps

David

[Kasiop]

Thanks a lot, indeed I had to add a )!!

And I have chanegd a little the formula:

Remove Duplicate = IF(ISBLANK(MAX([solution])) && (ISBLANK(MAX([description]))),1,0)

Thanks! It is working!!!