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 ,

 

you don't see this?

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

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional
    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.