Relationship for filter data from multiple tables

[x0]

Hello Everyone , 

Need your support for making relationship, 

explain you my sceanrio 

i have total 4 tables and now in 4 tables i have some common columns , like ( leasing agent , Property , custom date ) 

i created relationship using drag and drop same columns some rellationship is active and some are not active . 

on my visual i use matrix and i add multiple values from all table i add all table neccesory columns to see data now i also add 3 slicer which is filter data on 3 slicer i add property name , custom date , and leasing agent 

how can i achive goal to see accurate data here is screen shots of my sceanario 

can i get help to see by filter and accurate data ?

Thanks. 

[Anonymous]

Hi @x0 ,

The first thing I would suggest is that you are joining the four tables using custom date and then using summarize to generate a dimension table containing leasing agent , Property , custom date.

For slicer, you can use for example var _Property = selectvalue('dimtable' Property),to get the value of slice and then match it with the data in the table, depending on the actual requirement.

This may not be the easiest way to do it, I hope it helps and good luck with everything.

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly

[x0]

Hello @Anonymous 

can you explain me the way to configure this setup as you suggested ? 

do i need to create Column or table or you mean to say i will apply on existing table custom table ? 

please give me more detail for solution 

[x0]

Hello @Anonymous 

As of now i created custom table which can getting all table information of perticuler 3 columns for slicer value 

i created the custom table using this DAX 

CustomTable = UNION(

    SELECTCOLUMNS('Conversion', "LeasingAgent", 'Conversion'[Leasing Agent], "Property", 'Conversion'[Property], "CustomDate", 'Conversion'[CustomDate]),

    SELECTCOLUMNS('Move ins', "LeasingAgent", 'Move ins'[Leasing Agent], "Property", 'Move ins'[Property], "CustomDate", 'Move Ins'[CustomDate]),

    SELECTCOLUMNS('J Turner dashboard', "LeasingAgent", 'J Turner dashboard'[Leasing Agent], "Property", 'J Turner dashboard'[Name of the property], "CustomDate", 'J Turner dashboard'[CustomDate])

)

and then i created relationship between all table to this custom table 

but still my value is diffrent and dosent match with actual one.