Measure not giving the value proper

[madhushree]

Measure not giving the value proper:
I have used below measure to calculate the revenue based on year-month field.
Price = sum('table'[amount])
And it is giving me wrong result!!
Below screenshot shows what exactly i needMeasure not giving the value proper:
I have used below measure to calculate the revenue based on year-month field.
Price = sum('table'[amount])
And it is giving me wrong result!!

Here price is getting doubled sometimes dont know why?!!

Can anyone help me with this.

[v-sihou-msft · Accepted solution]

@madhushree

You must have other columns/filters to slice your measure. Otherwise your amount should aggregate on Year-Month fields. Even you select "do not aggregate". The amount must be separated based on other group column. You may change your measure into:

Price =
CALCULATE (
    SUM ( Table[Amount] ),
    ALLEXCEPT ( Table, Table[Year-Month], Table[Group] )
)

Regards,

[mattbrice]

Assuming you have put 'Ar maned' and 'Amount' on the "rows" of the visual, then for example in your third row shown, your measure SUM('table'[amount]) will sum up all the values in 'table' where Ar maned = 201705 and Amount = 28.95.  So you must have 2 rows in the table that match this criteria which is why you are getting the results doubled like you are.  Some rows meet the criteria twice (or more.  At bottom of visual i see some results 4x Amount).