Forum Discussion

Johnsnowlife's avatar
Johnsnowlife
Icon for Helper III rankHelper III
8 years ago
Solved

Creating lookthrough from 1 Fact table to another Fact table

I have 2 Fact Tables and I want to be able to create a pie chart with a hierarchy using the info from both tables. Fact Table 1: Is a Client Table showing the investment products the client owns.  ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Johnsnowlife,

    Please review this modified PBIX file.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Johnsnowlife,

Could you please post expected result in table based on the sample data in your PBIX file?

Regards,
Lydia

Johnsnowlife's avatar
Johnsnowlife
Icon for Helper III rankHelper III
8 years ago

The results tab on this excel sheet shows the desired result