Incorrect sum calculated

Hi poojik,

I'm assuming that you are using a measure, in this case the calculations are made taking into account the context of the formula, so when you get to the total it's also calculated in that way and not the sum of the previous values, you need to place that value around aggregator.

Create a second measure with the following code to use on your table:

Measure 2 =
IF ( HASONEFILTER ( Table[Name] ); [Combined Units]; SUMX ( Table; Combined Units] ) )

For better performance change the Table in the SUMX by ALL( Colum 1 , column 2, ...) and choose all the columns need for grouping/sorting instead of placing the all table.

Ths formula calculate the measure on every single row, and on the total since it has no value it sums the previous rows.

Regards,

MFelix

HI poojik,

When you do a measure it's calculated based on context, so the formula that you have is calculating the division by the current row it will give you 1, you need to something like this:

One third of Unit Count =
IF (
    accounts[Combined Units]
        < CALCULATE ( ( SUM ( accounts[Unit Count] ) / 3 ), ALL ( Accounts[Unit Count] ) ),
    "Less than one thrid",
    "Greater than one third"
)

Regards,

MFelix