Forum Discussion

lundande's avatar
lundande
Frequent Visitor
4 years ago
Solved

Filter dataset for SELECTEDVALUE() using SEARCH()

I have a data set of 15 million rows that needs to be filtered based on a value that can appear in a any one of 6 seperate columns ( not a great dataset). I concatenated these columns so I can use SE...
Need Help
  • smpa01's avatar
    smpa01
    4 years ago

    lundande  does this work?

    Measure =
VAR company =
    SELECTEDVALUE ( 'All Columns'[COMPANYNAME] )
RETURN
    CALCULATE (
        MAX ( 'All Columns'[COMPANYNAME] ),
        SEARCH ( company, 'All Columns'[Search Column], 1, -1 ) > 0
    )
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

lundande  does this work?

Measure =
VAR company =
    SELECTEDVALUE ( 'All Columns'[COMPANYNAME] )
RETURN
    CALCULATE (
        MAX ( 'All Columns'[COMPANYNAME] ),
        SEARCH ( company, 'All Columns'[Search Column], 1, -1 ) > 0
    )
lundande's avatar
lundande
Frequent Visitor
4 years ago

Looks like MAX is what I was missing! Thank you for the help.