Forum Discussion

jeggen's avatar
jeggen
Helper II
6 years ago
Solved

Filter Dataset Two Ways in Two Tables

I am hoping for some help in figuring out how to accomplish the following.   I have the following two tables. Partnerships - Lists all of our partnership with data in the following format. This i...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi jeggen ,

     

    you could remove the partner name from the table, but the Measures participant and attendee are necessary.

    But you can change the name an the value of this measures.

     

    For example like this:

    Attendee =
IF (
    ISBLANK (
        CALCULATE (
            COUNTROWS ( Meetings ),
            USERELATIONSHIP ( Partnerships[Column1], Meetings[Attendee ID] )
        )
    ),
    BLANK (),
    " - "
)

     Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

jeggen's avatar
jeggen
Helper II
6 years ago

mwegener 

This seems to be what I am looking for, can you explain what you did to make this work?

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

I have created an active and inactive relationship and controlled with the measures and the function userelationship, which should be used.

https://dax.guide/userelationship/

 

 

  • jeggen's avatar
    jeggen
    Helper II
    6 years ago

    I don't see any measures in the file you shared with me. Am I missing something?

     

    Also in the real data it is not allowing me to do one:many relationships with the partnership id column, despite the fact that there are no duplictes. Will that cause any issues?

    • mwegener's avatar
      mwegener
      Most Valuable Professional
      6 years ago

      Hi jeggen ,

       

      you don't see this?

      • jeggen's avatar
        jeggen
        Helper II
        6 years ago

        Sorry, I missed those somehow.

         

        I now am able to get this to work in my real data but wondering if it's possible to hide some of these columns?

         

        E.g. I would want to hide the participant and attendee columns since those would just add confusion to the end user. I also don't really need to show the partner name in either table, but am assuming this will not filter properly if those are gone.