Forum Discussion

x0's avatar
x0
Helper I
2 years ago

Relationship for filter data from multiple tables

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 , c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
x0
Helper I
2 years ago

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's avatar
    x0
    Helper I
    2 years ago

    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.