Forum Discussion

GuidoPinares's avatar
GuidoPinares
Helper I
3 years ago
Solved

Active and Inactive Relationships help!

Hi Community,   Thanks for any help!   I have the following data schema:     I would like as a result All Prescribers that doesnt exists in "OActivities" and "Activities" Tables, but the...
Need Help
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    3 years ago

    GuidoPinares , Prescribers is a dimension, it should not join with another dimension employee. Also avoid Bi-Directional join

     

    In case you want just to filter the slicer based on employee refer

    How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi GuidoPinares ,

You can create a measure [Flag] as below and apply a visual-level filter with the codition ([Flag] is 1😞

Flag =
VAR _selpres =
    SELECTEDVALUE ( Prescribers[PrescriberID] )
VAR _oactabs =
    UNION (
        VALUES ( OActivities[PrescriberID] ),
        VALUES ( Activities[PrescriberID] )
    )
VAR _selestab =
    VALUES ( Sales[PrescriberID] )
RETURN
    IF ( NOT ( _selpres ) IN _oactabs && _selpres IN _selestab, 1, 0 )

 

If the above one can't help you get the desired result, please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards