Forum Discussion

michaelshparber's avatar
michaelshparber
Advocate V
6 years ago

Calculated Measure from two tables

I have two tables: Sales and Bundle Details. In my Sales table - some of the sales are shown as Bundles - without Product. The other table shows these bundle details, but it doesn't show all sales ...
Need Help
camargos88's avatar
camargos88
Community Champion
6 years ago

Hi michaelshparber ,

 

Check this file: Download PBIX 

 

I just appended the bundle table in the sales table and filtererd the bundle rows out. Also I created a new column to indentify the bundles transactions.

 

 

 

michaelshparber's avatar
michaelshparber
Advocate V
6 years ago

Hi Ricardo camargos88 ,

Thanks, but I stated that I am looking for a solution WITHOUT appending the tables.

In my real scenario the two tables are quite different so I cannot append them.

Can you think of another way, please?

Thanks!

  • camargos88's avatar
    camargos88
    Community Champion
    6 years ago

    michaelshparber ,

     

    I've merged them into sales tables, the file is updated.

    Does it work ? If no let me know.