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 , 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. 

Need Help

3 Replies

  • 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.