Forum Discussion

jeggen's avatar
jeggen
Icon for Helper II rankHelper 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.

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi jeggen ,

 

check this out.

 

You may download my PBIX file from here.
Hope this helps.

 

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
Icon for Helper II rankHelper 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
    Icon for Most Valuable Professional rankMost 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
      Icon for Helper II rankHelper 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
        Icon for Most Valuable Professional rankMost Valuable Professional
        6 years ago

        Hi jeggen ,

         

        you don't see this?