USERELATIONSHIP with text column

Question

Im trying to filter a text-kolumn in a dimension-table based on a non-active relationship between two tables. Ive googled, searched this forum and tried to figure this out for myself for several hours but no luck so far so hopefully someone here can give me a hint on how to solve this.To demonstrate my problem lets say I have four tables:&nbsp;MonthTableBaseMonthBaseKey MonthBase1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2018-012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2018-02&nbsp;MonthTableCompareMonthKey&nbsp;&nbsp;&nbsp;&nbsp; MonthCompare1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2018-012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2018-02&nbsp;FactOrderMonthKey&nbsp;&nbsp; CustomerKey1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;DimCustomerCustomerKey&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CustomerName1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jane2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; John3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Frank&nbsp;I want to create two slicers - MonthBaseName Och MonthCompare and then list the CustomerName for the respecive selection in two separate tables.When selecting 2018-01 in the first slicer i want a table showing Jane and John in two separate rows and at the same time I want to select 2018-02 in the second slicer and have another table listing Jane and Frank. I can get it to work if I want to count the distinct CustomerNames from the selection but it wont work when I try to list the names.&nbsp;(I need to read from this Fact-table since me databasemodel is a lot more complicated then this and I have several measures on that fact-table and its surrounding dimension-tables so creating a copy just to be able to show the names correctly is not the solution for me.)&nbsp;How can I do this in Power BI?

v-jiascu-msft · Answer

Hi&nbsp;Hebj,
&nbsp;
Please check out the demo in the attachment. You just need to active the "Edit interactions". Please refer to the snapshot below.

&nbsp;
Best Regards,Dale

v-jiascu-msft · Answer

Hi&nbsp;Hebj,
&nbsp;
Could you please mark the proper answers as solutions?
&nbsp;
Best Regards,
Dale

Forum Discussion

USERELATIONSHIP with text column

2 Replies

Related content

RLS and USERELATIONSHIP problem

Calculated Column: RELATED & USERELATIONSHIP

USERELATIONSHIP problems with n:m-relationship

Multiple Date Columns and USERELATIONSHIP

Calculated columns: USERELATIONSHIP or LOOKUPVALUE?