Forum Discussion

zamurr's avatar
zamurr
Microsoft Employee
10 years ago

DAX - SelectColumns->Filter->Contains Syntax

Problem   I want to filter my dataset while performing a DAX query. The problem i am having is setting the formula up correctly.  From my understanding Contains takes a (table, comparision that ret...
zamurr's avatar
zamurr
Microsoft Employee
9 years ago

After my last post i realized that i needed to treat my DAX created table as the data table for the FILTER functions. Find the bold and underlined text to see my changes.

 

 

FlatTable = FILTER(SELECTCOLUMNS(
build,
"Index",build[Index],
"MachineID",build[Machine],
"UserAlias",build[Alias],
"Branch",build[Branch],
"Directory",build[StartPath],
"BuildCommand",build[CommandLineString],
"Razzle Cmd",build[Arguments],
"Clean",build[Clean],
"Parent",build[Parent],
"BuildTime",build[BuildTime],
"MachineType",LOOKUPVALUE(MachineInfo[Model],MachineInfo[MachineName],build[Machine]),
"Manager",LOOKUPVALUE(Shell[Org_Mgr],Shell[Org_User],build[Alias]),
"DM",LOOKUPVALUE(ShellDev[Org_DM],ShellDev[Org_User],build[Alias]),
"DateTime",build[Time]), [Directory] = "shell")

 

 

v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

Hi zamurr,

This one should work.

So what is your current situation?

Regards

  • zamurr's avatar
    zamurr
    Microsoft Employee
    9 years ago

    It did not like the syntax. i actually moved on from this problem because i decided that i could filter with the slicers. I was hoping that creating a table using DAX would have made my querying faster, but that doesn't seem to be the case.