inactive relationship in visual tables

Hi,

Powerquery can do this for you using merge tables.

Maahmohammed 
I think you can use LOOKUPVALUE or RELATED dax functions to fix this issue.

If you provide more details/sample data, It'll be great for us to fix the issue.

If you need information about above DAX functions, pls follow the below links
LOOKUPVALUE function (DAX) - DAX | Microsoft Learn
RELATED function (DAX) - DAX | Microsoft Learn

Thanks!

Maahmohammed 
if I understood your requirement correctly, you need to build a table visual which will take a 1 column from first table and 2nd column from another table. Both tables having inactive relationship and both should be column. if it is, then consider the below model,

I have taken two tables, DimDate and FactSales and both having inactive 1 to many relationship. 

I just wanted to show unique list of Order id (FactSales) under each month & Year ( DimDate).

For example, in Sep2013, it is showing 4 unique order.
The easy way to achive this, create a measure and then hide this.

Step 1 : I have created a measure which will help to active the inactive relationship,

CALCULATE(
    DISTINCTCOUNT( FactSales[OrderID(DG)] ),
    USERELATIONSHIP( DimDate[DateSK], FactSales[OrderDateSK] )
)

Step 2 : Go to the Values and Column header section and turned off the text wrap option.

Below is the attached file.

https://we.tl/t-U4GyRbCX46

Hope it helps.

Regards

sanalytics

If it is your solution then please like and accept it as solution