Divide SUM values from 2 tables (with date table/reference)

[Anonymous]

Hi,

I have a table which shows SUM values from 2 different tables - I would like to calculate:

Delta Date / Tons

The data have a Calender table as common reference,

How would I calculate this?

[AlB]

Hi @Anonymous 

It would be best to use explicit measures rather than implicit ones. Create a measure:

Measure =
DIVIDE ( SUM ( DataLog[DeltaData] ), SUM ( THA_JWIOVN[Tons] ) )

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[PhilipTreacy]

Hi @Anonymous 

Create a measure

Measure = DIVIDE( SUM('DataLog'[Delta Data]), SUM('THA_JWIOVN'[Tons]))

Regards

Phil

[amitchandak]

@Anonymous , Try a measure like

divide(Sum(data_log[Delta Date]), sum(THA_JWIOVN[Tons]))