Forum Discussion
Filter Dataset Two Ways in Two Tables
- 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.
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.
See this power BI file:
https://www.dropbox.com/s/2lap5vpno4aqk1d/Example%20Data.pbix?dl=0
- mwegener6 years ago
Most Valuable Professional
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.- jeggen6 years ago
Helper II
This seems to be what I am looking for, can you explain what you did to make this work?
- mwegener6 years ago
Most Valuable Professional
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/