Forum Discussion

victorlopes1998's avatar
victorlopes1998
New Member
3 years ago
Solved

Sumx() returning wrong total

Hello all!   I'm trying to monthly my weight by distinct count of dates doing:   MONTHLY WEIGHT = SUMX(Plan1, DIVIDE(Plan1[WEIGHT],DISTINCTCOUNT(Plan1[DATE])))     And I need to get th...
Need Help
Tutorial Requests
  • DataInsights's avatar
    DataInsights
    3 years ago

    victorlopes1998,

     

    Try this measure:

     

    MONTHLY WEIGHT = 
VAR vTable =
    ADDCOLUMNS (
        SUMMARIZE ( Plan1, Plan1[DESTINY], Plan1[ORIGIN] ),
        "@Weight", CALCULATE ( SUM ( Plan1[WEIGHT] ) ),
        "@CountDistinctDate", CALCULATE ( DISTINCTCOUNT ( Plan1[DATE] ) )
    )
VAR vResult =
    SUMX ( vTable, DIVIDE ( [@Weight], [@CountDistinctDate] ) )
RETURN
    vResult

     

     

DataInsights's avatar
DataInsights
Super User
3 years ago

victorlopes1998,

 

Try this measure:

 

MONTHLY WEIGHT = 
VAR vTable =
    ADDCOLUMNS (
        SUMMARIZE ( Plan1, Plan1[DESTINY], Plan1[ORIGIN] ),
        "@Weight", CALCULATE ( SUM ( Plan1[WEIGHT] ) ),
        "@CountDistinctDate", CALCULATE ( DISTINCTCOUNT ( Plan1[DATE] ) )
    )
VAR vResult =
    SUMX ( vTable, DIVIDE ( [@Weight], [@CountDistinctDate] ) )
RETURN
    vResult

 

 

  • victorlopes1998's avatar
    victorlopes1998
    New Member
    3 years ago

    Thank you!!! It works fine and solve my problem!!