compare two matrix of two different tables

[oren]

hi,

i have 2 same tables and i build 2 matrix table from them. i want to have another that show me the differences : 

i created a new measure that should sow it to me bu it doesn't  works -

and when i create a new matrix with the new measure i getting this :

(it should all be Zero's) 

[lc_finance]

Hi @oren ,

the reason is that you are calculating the sum of all the discounts. For example, you are calculation 10% discount + 15% discount = 25% discount, etc.

You can either:

- use AVERAGE instead of SUM in your function. Here is the doc for the AVERAGE formula: https://docs.microsoft.com/en-us/dax/average-function-dax

- recalculate the discount on the total = discount value / total value

Does this help you?

LC

Interested in Power BI and DAX formulas? Check out my blog at www.finance-bi.com

[oren]

hi

it still now working

(i have other BI report that it does work - and i can't remember what i did differently?! )

and maybe this it one of the reasons - 

 i cannot make relations for more than one table:

thank you!

[v-xicai]

Hi @oren ,

You may delete the relationship between the table groups and Data (2), active the relationship between the table size and Data (2), then change the Cross filter direction of relationships among all these tables above from Single to Both , which will take these tables treated as a single table.

You can learn more about relationship :https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[oren]

thanks but i can do more than one relationship as "both"

after i do one (data(2))  , if i try to do it for the other table (data) , i get this error -

[oren]

looks like this is my problem -

[oren · Accepted solution]

i found the solution !!!

when exporting the data- need to export the 2 "data" tables from different  source- means cannot import the data 2 times from the same table (in excel - in my example). 

i dueled  the table to different sheet in the excel and import the second table from there - and now it works

thanks !

[lc_finance]

Glad to hear you found a solution!

LC