Forum Discussion

Euro0681's avatar
Euro0681
Helper II
3 years ago
Solved

SUMX Incorrect Values

I Have created a Measure (Measure 1) and then created another measure (Measure 2) to try and correct the totals and it's giving wrong values at a row level causing the total to be wrong as well. ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  Euro0681 ,

     

    Here are the steps you can follow：

    1. Create measure.

    If you want to display Total at the end, you can use the following function:

    Measure2 =
var _table1=SUMMARIZE('Table', 'Table'[Column],"Value",[Measure1])
return
IF(
    HASONEVALUE('Table'[Column] ),
    [Measure1],SUMX(_table1,[Value]))

    If you want to display Total in full, you can use the following function:

    Measure 3 = SUMX(ALL('Table'),[Measure1])

    2. Result:

     

    Best Regards,

    Liu Yang

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Try SUM() instead of SUMX()

Euro0681's avatar
Euro0681
Helper II
3 years ago

I cant use SUM to sum up a measure.. EXAMPLE: SUM([Measure 1])