Perform a calculation between 2 tables

game1 — Fri, 01 Mar 2024 14:18:26 GMT

Hello,

Suppose I have these two tables. I would like to calculate a measure to divide table 1 and table2:

Re: Perform a calculation between 2 tables

talespin — Wed, 21 Feb 2024 09:52:55 GMT

I have joined these two tables on Date column, with one to many relationship and single.

Create this measure.

Measure =

VAR _Date = SELECTEDVALUE(Table1[Date])

VAR _Price = CALCULATE( SUM(Table1[Price]) )

VAR _Item = CALCULATE( SUM('Table'[Items]) )

RETURN DIVIDE( _Price, _Item)