Data Difference based on different column

[Wicak]

i connected the three tables using the material table. I want to get the result of the difference value of the three tables. any suggestions so that the DAX doesn't just use this method? Example Dax, sum ( Material A ) - sum ( Material B ). but, in this way only compare 2 tables

Thanks

[v-zhangti · Accepted solution]

Hi, @Wicak 

Is this the result you expected?

Best Regards,

Community Support Team _Charlotte

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

[tamerj1]

@Wicak 

Would you please explain how did you reach to this result?

[daXtreme]

Why 3 tables when 1 is enough? Just create this table instead (it's called melting or unpivoting):

Material | SystemNo   | Value

A            | System1     | val1

B            | System2     | val2

...

I hope you get the gist. Power BI does not like to work with the tables you've got. It likes the table I showed you. Once you've got such a table, it'll be easy to do anything...

Having such a table you create a measure: [Total] = SUM( T[Value] ) and by slicing the table by Metarial/SystemNo, you can build from this base measure any measure you need.