Forum Discussion

laurentalp's avatar
laurentalp
Frequent Visitor
4 years ago
Solved

Filter a column using other column in the same table

I have a table with all procedures from a hospital, but with more fields that I use in another page. Like this: (let's call this table 'PROCEDURES') Procedure Requesting doctor specialty Perf...
Need Help
  • laurentalp's avatar
    laurentalp
    4 years ago

    I achieved the result using other solution:
    Instead all procedures in one table, I made one table with only medical appointments and other with exams and other procedures, and created a relationship between performing doctor on table A and requesting doctor on table B.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi， laurentalp ；

You should add another table from [Performing doctor specialty] column ;

filter = VALUES('Table'[Performing doctor specialty])

Then create a flag measure.

flag = 
IF (
    ISFILTERED ( 'filter'[Performing doctor specialty] ),
    IF (
        MAX ( 'Table'[Requesting doctor specialty] )
            IN ALLSELECTED ( 'filter'[Performing doctor specialty] ),
        1,
        0
    ),
    1
)

add the visual filter.

The final show:


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

  • laurentalp's avatar
    laurentalp
    Frequent Visitor
    4 years ago

    Thanks for your reply.
    It's almost what I need, but in first table I need total appointments per "Performing doctor specialty" too, not only use as a filter. I tried to use a relationship, but it use the relationship for filter, which i don't want to.