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 ,

 

could you provide some sample data?

 

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?