Forum Discussion

rhcentennialh's avatar
rhcentennialh
Helper II
6 years ago
Solved

Find Distinct Data - Based On Two Columns

I have a database where I would like to identify unique codes that a particular person has not identified or coded. Below is an example of my problem.   Problem: I would like to exclude all of the ...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi rhcentennialh ,

     

    We use the following measure and get the expected result:

     

    Not identified by Outside = 
IF (
    SELECTEDVALUE ( 'Table'[Code] )
        IN SELECTCOLUMNS ( FILTER ( ALLSELECTED ( 'Table' ), [Internal vs Outside] = "Internal" ), "c", [Code] ),
    BLANK (),
    "YES"
)

     

     

     

    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi rhcentennialh ,

     

    Can it filter the data you want if we put the following measure into the Visual Filter then set the condition as greater than zero?  Please try it without the measure in the value filed of table visual.

     

    Not identified by Outside 2 = 
IF (
    SELECTEDVALUE ( 'Table'[Code] )
        IN SELECTCOLUMNS ( FILTER ( ALLSELECTED ( 'Table' ), [Internal vs Outside] = "Internal" ), "c", [Code] ),
    0 ,
    1
)

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rhcentennialh's avatar
rhcentennialh
Helper II
6 years ago

I am still running into issues, i know its something i am missing on my end.

 

However, could i change the formula you previously provided (Below) to reference a Non-Calculated column? Instead of [Internal vs Outside] i would change this to [Teacher]. I have a list of 5 teachers that i need to reference that would reflect the Internal vs Outside group. Could i do the following with an OR statement? Please let me know what you think.

 

New Solution with a OR Statement

Not identified by Outside = 
IF (
    SELECTEDVALUE ( 'Table'[Code] )
        IN SELECTCOLUMNS ( FILTER ( ALLSELECTED ( 'Table' ), [Teacher] = or("Teacher 1", or("Teacher 2", or("Teacher 3", 
or("Teacher 4", "Teacher 5"))))
), "c", [Code] ),
    BLANK (),
    "YES"
)

 

 

Previous Provided Solution

Not identified by Outside = 
IF (
    SELECTEDVALUE ( 'Table'[Code] )
        IN SELECTCOLUMNS ( FILTER ( ALLSELECTED ( 'Table' ), [Internal vs Outside] = "Internal" ), "c", [Code] ),
    BLANK (),
    "YES"
)

 

rhcentennialh's avatar
rhcentennialh
Helper II
6 years ago

When i try the OR solution i get the following error