Forum Discussion

dw700d's avatar
dw700d
Post Patron
3 years ago
Solved

Filter only Impacts one column

I have a table with three columns from my data set and a fourth column that is a measure called relationships. The Measure is as follows: >>>Relationship = DISTINCTCOUNTNOBLANK('Aggregate Officer'[Un...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi dw700d ,

     

    As far as I know, if you use [Team Member] column which is related to other columns in your visual, these columns like [Job Title]/[Name] will be filtered.

    Here I suggest you to create an unrelated Dim Team Member table for the slicer.

    Dim Team Member = 
VALUES('Aggregate Officer'[Team Member])

    Measure:

    Relationship =
CALCULATE (
    DISTINCTCOUNTNOBLANK ( 'Aggregate Officer'[Unique identifier] ),
    FILTER (
        'Aggregate Officer',
        'Aggregate Officer'[Team Member] IN VALUES ( 'Dim Team Member'[Team Member] )
    )
)

    And turn on "Show items with no data", result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

olgad's avatar
olgad
Resident Rockstar
3 years ago

 

  • Hi, go to the name and click on the arrow down to pick show the items with no data
dw700d's avatar
dw700d
Post Patron
3 years ago

olgad that does not work because the rows with blanks in the example above have no connection with Team Member A

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi dw700d ,

     

    As far as I know, if you use [Team Member] column which is related to other columns in your visual, these columns like [Job Title]/[Name] will be filtered.

    Here I suggest you to create an unrelated Dim Team Member table for the slicer.

    Dim Team Member = 
VALUES('Aggregate Officer'[Team Member])

    Measure:

    Relationship =
CALCULATE (
    DISTINCTCOUNTNOBLANK ( 'Aggregate Officer'[Unique identifier] ),
    FILTER (
        'Aggregate Officer',
        'Aggregate Officer'[Team Member] IN VALUES ( 'Dim Team Member'[Team Member] )
    )
)

    And turn on "Show items with no data", result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.