Forum Discussion

iwf's avatar
iwf
Icon for Helper I rankHelper I
8 years ago
Solved

Data Slicer from second level table

Hi, can anybody help me with slicer. I have first table with data. First column is respondent email. In second table I have all customers emails and company ID. In third table I have all companies. ...
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi iwf,

 

Here I made a sample and created the relationships between tables as below. Here the cross filter direction should be both as you want to slice Respondents based on Company values.

 

 

Then we can achieve your goal.

 

 

For more details, please check the pbix as attached. If it doesn’t meet your requirement, kindly share your sample data to me.

 

https://www.dropbox.com/s/irmqzxcwz492r4z/relat.pbix?dl=0

 

Regards,

Frank

  • iwf's avatar
    iwf
    Icon for Helper I rankHelper I
    8 years ago

    Frank,

     

    thank you for answer. I see, that you have Compamy ID in all 3 tables. That is not my case. I have:

     

    Table 1

    Respondent ID, respondent email, Answers

     

    Table 2

    Client email, ParentCompany ID etc(client charakteristics)

     

    Table3

    Company ID, Company Name (account charakteristics)

     

    I know, that I can merge all 3 tables together and get Company ID into respondent table. I solved the problem that way, but this way is not good while refreshing the date (merge 3 table) is time consuming. I thought that if I relate the tables with this way - respondent email - client email + ID company - Id company + name I can avoid to merge tables into 1 super table.

    I have the answers from survey web page, the other two table are from MS CRM, so the client table and company table are huge (with many related entities within)

    • v-frfei-msft's avatar
      v-frfei-msft
      Icon for Community Support rankCommunity Support
      8 years ago

      Hi iwf,

       

      Again I made a sample as your description, and the relationship between tables is like the picture as below.

       

       

      Then we can slice Respondents based on Company values.

       

       

      For more details, please check the pbix as attached.

       

      https://www.dropbox.com/s/dzw94ozz7vmjfqb/relat2.pbix?dl=0

       

      Regards,

      Frank

      • iwf's avatar
        iwf
        Icon for Helper I rankHelper I
        8 years ago

        Hi,

         

        it is curious, now it work also with my pbix. I think it had something to do with cross filtr direction or somethinkg.