Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Display distinct values with multiple OR filters

Hello!   I would like to consult to you this problem --- so I have the an ID, name, Col1, Col2, and Col3 columns..   I would like to display the distinct ID and name column into a table with (col...
DAX
Distinct
OR function
  • az38's avatar
    az38
    6 years ago

    sorry, Anonymous my bad

    try new table

    = 
DISTINCT(
SELECTCOLUMNS(
FILTER(
'Query1';( ([col1] >=5 && [col1]) || ([col2] >=5 && [col2]) || ([col3] >=5 && [col3] ) )
)
);
"ID";
[ID]
)

    do not hesitate to give a kudo to useful posts and mark solutions as solution

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

try to create newtable

= 
DISTINCT(
SELECTCOLUMNS(
FILTER(
'Query1'; OR( ([col1] >=5 && [col1]);OR(([col2] >=5 && [col2] );([col3] >=5 && [col3] )) )
)
);
"ID";
[ID]
)

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi az38,

     

    not sure if i typed it correctly, and is it really new table? i used new column, how to create new table through this?

     

     

    • az38's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      sorry, Anonymous my bad

      try new table

      = 
DISTINCT(
SELECTCOLUMNS(
FILTER(
'Query1';( ([col1] >=5 && [col1]) || ([col2] >=5 && [col2]) || ([col3] >=5 && [col3] ) )
)
);
"ID";
[ID]
)

      do not hesitate to give a kudo to useful posts and mark solutions as solution

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        az38 ,

         

        Thanks! i also created a new column with a formula also the same, same results as well but without the selectedcolumn function, i am going to use this. thanks! 🙂