Addition Value

[Shreeram04]

Hi All,

My Requirement is I have a set of data from Jan, Feb, Mar, Apr, Jun, Jul, and Aug. If I select July in the filter its shows the total as a multiplication of July month value into the count of months which have value in the data.

For Example the value for each month

Jan->10

Feb->20

Mar->10

may->

Apr->30

Jun->5

Jul->10 

if I select Jul means I want calculations like (10*5)=50. May month have no values so it should take value remaining 5 months have only value so we take count as 5.

Please help to find a solution for this one.

Thanks in Advance.

[amitchandak · Accepted solution]

@Shreeram04 , Try a measure like 

Measure =

var _count = countx(Summarize(All(Table), Table[Month], "_1", sum(Table[Value]) ), [Month])

return

_count*sum(Table[Value])