Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

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?

 

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try a measure like

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

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi Anonymous 

    Create a measure

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

    Regards

    Phil

  • AlB's avatar
    AlB
    Community Champion
    5 years ago

    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